Data Dictionary Generator: CREATE TABLE with AI Descriptions

Turn a CSV, Excel, JSON or Parquet file into a documented table: a CREATE TABLE script where every column has a clear description.

A table without descriptions is hard to use six months later. Writing a description for every column by hand takes time, so it is often skipped.

The Data Dictionary Generator reads your file, guesses the column types in your browser, and asks your AI to describe each column from its statistics. The descriptions are added to the script in the right style for your database.

That means COMMENT ON for PostgreSQL and Oracle, inline COMMENT for MySQL, extended properties for SQL Server and comments for SQLite. You can edit every description, then download the .sql file, or a Markdown or CSV data dictionary to share.

Open the Data Dictionary Generator

How to use the Data Dictionary Generator: step by step

  1. Open the Data Dictionary Generator.
  2. Paste your Gemini API key.
  3. Load your file and choose your database.
  4. Click Generate descriptions, edit if needed, then copy or download.

When to use the Data Dictionary Generator

  • Documenting a new table before you create it
  • Sharing a data dictionary with a team
  • Writing database comments from an old spreadsheet
  • Moving a table between database types

Tip: Check the guessed column types before you run the script on a real database.