SQL Schema to Data Dictionary

Read supported SQL schema definitions and export a data dictionary as CSV, JSON, Markdown, HTML or XLSX.

On-device No sign-up Free to use

Build data dictionary controls

Showing an example. Edit to see your own.

?

Up to 100,000 UTF-8 bytes, 20 tables and 200 columns total. A strict declared subset, not a complete SQL validator.

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

Document the four declared customer columns and create an empty import template.

Read 1 table declaration and 4 columns.

Loading the tool. Your result will appear here.

https://usefreetools.net/sql-schema-data-dictionary · 20 November 2026

Was this helpful?

How to use SQL Schema to Data Dictionary

  1. Paste CREATE TABLE declarations using the supported plain types, defaults and key constraints. Do not paste a full database dump.
  2. Run the parser. If a construct is refused, check the documented subset rather than deleting an important constraint just to obtain output.
  3. Review declared types, nullability, defaults and grouped primary, unique and foreign keys.
  4. Download the dictionary as CSV, JSON, Markdown, HTML or XLSX. Separate table import templates contain only column headings, with no records.

Example: SQL Schema to Data Dictionary

Document the four declared customer columns and create an empty import template.

You add
CREATE TABLE declarations: CREATE TABLE customers ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(120) NOT NULL, email VARCHAR(200) UNIQUE, active BOOLEAN DEFAULT TRUE );
You get
Read 1 table declaration and 4 columns.

Options

CREATE TABLE declarations
Up to 100,000 UTF-8 bytes, 20 tables and 200 columns total. A strict declared subset, not a complete SQL validator.

Supported inputs and limits

  • Up to 100,000 UTF-8 bytes, 20 tables and 200 columns in total.
  • Supported CREATE TABLE syntax includes listed plain types, bounded type parameters, NULL/NOT NULL, literal or supported current-date/time defaults, and primary, unique and foreign keys.
  • CHECK, generated columns, collations, auto-increment options and unsupported dialect extensions are refused.
  • No database is accessed or SQL executed.
  • Exports describe the supplied declarations; database-specific behavior still needs review.

Where your input is processed

This tool does not upload your inputs. See the limits for anything saved on your device.

Declared constraints are not a live schema check

The dictionary reports the supported SQL you supply. Nullability is shown as declared, and composite keys remain groups rather than separate unique columns. It does not infer descriptions or prove that a running database has the same schema. Keep unsupported constraints in the original SQL and review them with the relevant database tooling; removing them changes what the dictionary describes.

Questions about SQL Schema to Data Dictionary

Can it read any SQL dump?

No. Paste supported table declarations only. Other statements and unsupported clauses are refused.

Does the template include database data?

No. It contains column headers without records, for preparing an import.

Are types converted to a common database type?

No. The dictionary retains the declared type text so it does not silently reinterpret your schema.

Page updated · Project managed by Tony Hines · Report a problem with SQL Schema to Data Dictionary