Data dictionary generator
Paste your SQL CREATE TABLE statements — or upload a CSV / Excel file — and get a clean, exportable data dictionary with tables, columns, types, keys, and a place to document what each field means. Free, no signup, and it runs entirely in your browser.
Runs entirely in your browser — nothing is uploaded.
How it works
- Paste your DDL (
CREATE TABLEstatements) or upload a CSV / Excel file — each worksheet becomes a table. - The tool parses columns, types, nullability, and keys in your browser; for files it infers types from the sample rows.
- Fill in the business meaning for each column, then export to CSV or copy as Markdown.
Tired of maintaining a data dictionary by hand?
A dictionary goes stale the moment your schema changes. Inside Intellrise, the AI learns what your tables and columns mean from the questions you ask — and remembers those definitions permanently, so everyone gets consistent answers without anyone maintaining a spreadsheet. Ask your data in plain English and get charts, dashboards and reports on your own data and your own AI key.
Frequently asked questions
A reference that lists every table and column in a database with its data type, keys and — most usefully — what each field actually means in business terms. It keeps a team aligned on definitions.
No. Parsing happens entirely in your browser — whether you paste SQL DDL or upload a CSV or Excel file. Your schema and data never leave your machine, and there's no account or login required.
Common CREATE TABLE syntax from PostgreSQL, MySQL/MariaDB and SQL Server — quoted identifiers, typed columns, NOT NULL, DEFAULT, inline and table-level primary and foreign keys, and MySQL COMMENT.
It reads the header row as column names and infers each column's type (integer, number, boolean, date or text) from the sample rows, marking a column nullable when it finds blank values. Each Excel worksheet becomes its own table. Files can't carry keys or defaults, so those are left blank for you to fill in.
This free tool leaves meanings for you to type. Inside Intellrise, the AI learns what your fields mean from your questions and remembers them permanently — so you don't maintain the dictionary by hand.