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.
How to use the Data Dictionary Generator
Get a CREATE TABLE script with a description of every column, from a CSV, Excel, JSON or Parquet file.
- 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: id,name,age
1,Ada,36
2,Alan,41
Output: CREATE TABLE people (
id INTEGER NOT NULL, -- Unique id of the person
name TEXT -- Full name
);
Frequently asked questions
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.
Guides