Data Dictionary Maker

Make a data dictionary online: add a CSV, Excel file or CREATE TABLE script and get a described column list to edit and download. Free, with your own Gemini key.

Quick answer: Get a CREATE TABLE script with a description of every column, from a CSV, Excel, JSON or Parquet file.

Related: Data Dictionary Generator · Document Database Columns with AI · Generate SQL Column Comments · AI Data Dictionary Generator · AI Data Tools and Guides

How to use the Data Dictionary Maker

Get a CREATE TABLE script with a description of every column, from a CSV, Excel, JSON or Parquet file.

The Data Dictionary Generator writes a CREATE TABLE script with a description for every column. Load a CSV, Excel, JSON or Parquet file, choose your database and it produces documented SQL for PostgreSQL, MySQL, SQL Server, Oracle or SQLite. It uses your own Gemini key and only a summary of the data, and it saves hours of manual documentation.

1. Add your AI key
2. Load your file
3. Pick a database and generate

Tips

• You can edit any description before you copy or download.
• Descriptions are saved as comments in the script, using each database's own syntax.
• Download a Markdown or CSV data dictionary to share with your team.

Example

Input: orders.csv

Output: Column, type, description, examples

Browse by topic

• Parquet Guides and Free Parquet Tools
• CSV Guides and Free CSV Tools
• JSON Guides and Free JSON Tools
• Excel Guides and Free Excel Tools
• Data Privacy Guides and Free Tools
• Test Data Guides and Free Generators
• Data Cleaning Guides and Free Tools
• AI Data Tools and Guides
• Extract Data from Screenshots and APIs
• File Format Guides and Free Tools

Who uses Data Utility

• Free Data Tools for Marketing Lists
• Free Data Tools for Finance and Accounting Exports
• Free Data Tools for Developers
• Free Data Tools for Data Analysts
• Free Data Tools for Small Business

Frequently asked questions · Data format benchmark

Frequently asked questions

What is a data dictionary maker?

A tool that lists every column of a dataset with its type and a plain-English description. Data Utility writes the first draft with AI and you edit it.

Which databases are supported?

PostgreSQL, MySQL / MariaDB, SQL Server, Oracle and SQLite.

What is sent to Google Gemini?

Column names, types, statistics and, if you allow it, a few sample values. Your full file is never sent.

Are the column types correct?

Types are guessed from your data in your browser, not by the AI. Check them before you run the script.

What is the Data Dictionary Generator?

It writes a CREATE TABLE script with a description for every column, for PostgreSQL, MySQL, SQL Server, Oracle or SQLite. It uses your own Gemini key and sends only a summary of your data.

Related pages

• Data Dictionary Generator: Upload a CSV, Excel, JSON or Parquet file and get a CREATE TABLE script with a description for every column, for 5 databases. Use your Gemini key.
• Document Database Columns with AI: Describe every column of a table automatically. Load a CSV or Excel file and get CREATE TABLE with a comment on each column. Uses your own Gemini key.
• Generate SQL Column Comments: Generate COMMENT ON COLUMN statements and column descriptions for your table from a CSV, Excel, JSON or Parquet file. Free, bring your own Gemini key.
• AI Data Dictionary Generator: Generate a data dictionary from a CSV, Excel file or CREATE TABLE script: a clear description for every column. Free with your own Gemini key.
• Data Dictionary from a CSV File: Create a data dictionary from any CSV in seconds: column names, types and AI-written descriptions. Free, in your browser.
• Write Column Descriptions with AI: Let AI write clear descriptions for every column in your table or file, then export them as a dictionary or as SQL comments. Free, with your own Gemini key.

Topic guides

• AI Data Tools and Guides

Guides

• Data Dictionary Generator: CREATE TABLE with AI Descriptions