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.

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 · Generate SQL Column Comments · AI Data Tools and Guides

How to use the Document Database Columns with AI

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: order_id INT -- Unique id of the order

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

How does it describe the columns?

It looks at column names, types and statistics, then asks Gemini with your own key to write a short meaning for each column. Only a summary is sent, never the full file.

Which SQL dialects are supported?

PostgreSQL, MySQL, SQL Server, Oracle and SQLite, each with its own comment syntax.

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

Topic guides

• AI Data Tools and Guides

Guides

• Data Dictionary Generator: CREATE TABLE with AI Descriptions