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.

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 · Test Data Guides and Free Generators

How to use the Generate SQL Column Comments

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: customers.csv

Output: COMMENT ON COLUMN customers.email IS ...

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

Can I edit the descriptions?

Yes. Every description can be edited before you copy or download the script.

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.

Topic guides

• Test Data Guides and Free Generators

Guides

• Data Dictionary Generator: CREATE TABLE with AI Descriptions