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.

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

How to use the Data Dictionary from a CSV File

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.

Add your AI key
Load your file
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: A table of columns, types and descriptions

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

How do I make a data dictionary from a CSV?

Add the CSV to Data Dictionary, click generate, review the descriptions and download.

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.

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.
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

Guides

Data Dictionary Generator: CREATE TABLE with AI Descriptions