LocalDict

A SQL Server data dictionary in two minutes, without uploading your schema.

Run one read-only catalog query, paste the results, and get a searchable dictionary, a Markdown file for your repo or wiki, and a Mermaid ER diagram. It all runs in your browser tab.

Open the appSee the demo

Private by design

No install, no account, no database connection. Parsing and rendering happen in JavaScript on your machine. The page's Content-Security-Policy only allows requests back to this site, and the app sends nothing but a license key.

Useful output

Columns, types, nullability, PK/FK/unique, identity, defaults, and your MS_Description text. Click through foreign keys, see "referenced by", and spot undocumented columns.

Take it anywhere

Export a single self-contained HTML file, Markdown (GitHub, Azure DevOps and Confluence friendly), or Mermaid source you can drop into docs.

How it works

  1. Copy or download the catalog query (it reads sys.* views only, no row data).
  2. Run it in SSMS or Azure Data Studio, then Copy with Headers.
  3. Paste into the app. Search, export, done.

Pricing

Free

$0

Up to 15 tables per dictionary. All exports and the ER diagram included.

Start free

Pro

$24 one-time

Unlimited tables, same features. One license per person; use it on your own browsers. Not on sale yet.

FAQ

Does my data leave my computer? No. The metadata you paste is processed in the page. There is no backend that receives it. You can check with your browser's network tab, or load the page and then go offline: it still works (except the license check).

What versions are supported? SQL Server 2016 and later, and Azure SQL Database. The query uses standard catalog views.

What about descriptions? LocalDict shows MS_Description extended properties. It doesn't invent descriptions, and it flags columns that have none.

Limitations. Tables and columns only for now (no views, procedures, indexes or triggers). Very large diagrams can be slow to draw; the Mermaid source still exports.

Is this from Microsoft? No. Independent tool, not affiliated with Microsoft.