💙 Supporting healthcare non-profits: Metadataloop is free for 6–12 months. Contact Us to get started.
Documentation

Data Dictionary

Upload a SQL file to explore table metadata, column types, constraints, and business descriptions.

Upload a SQL file to extract table metadata.
No table selected
Upload a SQL file to get started
Column Type Constraints Description
No data — select a table from the sidebar
No schema loaded.

A searchable, exportable data dictionary in seconds

Upload a SQL DDL file or connect your active database, and every table and column becomes browsable in a searchable sidebar — with primary keys and foreign keys called out, and one click to export the whole thing to Excel for sharing with non-technical stakeholders.

How it works

  • Parse: Every CREATE TABLE block is parsed for columns, types, and constraints.
  • Browse: Use the sidebar filter to jump straight to any table by name.
  • Inspect: Column list shows type, nullability, and PK/FK badges at a glance.
  • Export: Download the full dictionary as an Excel workbook with one click.

Common use cases

Stakeholder documentation

Hand analysts and PMs an Excel data dictionary instead of raw DDL.

Onboarding new engineers

Give new hires a searchable reference for every table and column.

Compliance & audit prep

Produce a point-in-time schema reference for audits or reviews.

Live database documentation

Generate docs directly from your active database connection.

FAQ

What does the data dictionary include? Every table and column with its data type, nullability, and whether it's a primary key or foreign key — browsable in a searchable sidebar list.

Can I export it? Yes — click Export Excel to download the full dictionary as a spreadsheet you can share with non-technical stakeholders.

Can I generate it from my live database? Yes — if you're logged in with a saved database connection, switch to the live DB source to generate the dictionary from your real, current schema.

Is my schema stored anywhere? No. Uploaded files are parsed in-memory for the request only and are not retained.

⚠ Confirm Delete