Back to all posts

Best Database Documentation Tools in 2026: Compared and Reviewed

For the person who has to hand a database schema to colleagues who never open a database client, and is choosing the tool that writes the documentation.

On this page

Your colleagues keep asking what a table holds or what a column means, and the answer is in a database they never open. A documentation tool reads the schema and writes it out as pages they can read in a browser. DbSchema writes that documentation as HTML5, PDF or Markdown, with the diagram and every table and column comment. It reads the schema from the database or from a model file, DbSchema's own copy of the schema.

The pages that rank for this search also name dbForge Documenter, Redgate SQL Doc, SchemaSpy, Dataedo, dbdocs.io, Navicat and MySQL Workbench. Some of them also list database clients such as DataGrip, DBeaver and HeidiSQL, which show a schema but write no documentation. Every vendor fact below comes from the vendor's own pages, read on 11 November 2026.

What the documentation holds, and where the descriptions live

Useful database documentation holds:

  • a diagram of the tables and the foreign keys between them
  • every table and column, with its data type and whether it can be NULL
  • the primary keys, foreign keys, indexes and constraints
  • a description of each table and of each column whose name doesn't explain it
  • the date it was generated

Every tool on this page reads the tables, types and keys from the database itself. The descriptions are where the tools differ. In most databases, a table or a column can carry a comment, a description stored in the database. In PostgreSQL 18, you add one with COMMENT ON:

CREATE TABLE customers (
  id    integer PRIMARY KEY,
  email text NOT NULL
);
COMMENT ON TABLE customers IS 'Everyone who created an account';
COMMENT ON COLUMN customers.email IS 'Login and contact address';

The comments are now part of the schema, so any tool that reads the schema can print them. This query reads the columns back with their comments:

SELECT column_name, data_type,
       col_description('customers'::regclass, ordinal_position) AS description
FROM information_schema.columns
WHERE table_schema = current_schema() AND table_name = 'customers'
ORDER BY ordinal_position;
column_namedata_typedescription
idinteger
emailtextLogin and contact address

MySQL keeps comments the same way, with a COMMENT clause on the table or column. SQL Server keeps descriptions as extended properties, name-value pairs attached to a table or column. A description kept in the database stays when you change documentation tools, because the next one reads the same comments. Some tools keep the descriptions somewhere else, in a text file or in a database of their own:

Four rows. Comments in the database are read by DbSchema, dbForge Documenter, Redgate SQL Doc and SchemaSpy, which write HTML, PDF, Markdown or Word. A model file is read by DbSchema and MySQL Workbench. Dataedo keeps descriptions in its own repository and publishes a web portal, HTML, PDF or Excel. dbdocs.io reads a DBML text file and publishes a hosted web page

Database documentation tools compared

ToolReads the schema fromOutputDatabasesEdition or price with documentation
DbSchemathe database, or a .dbs model fileHTML5, PDF, Markdown100+ over JDBCPro; Community up to 12 tables per diagram
dbForge Documenterthe databaseHTML, PDF, MarkdownMySQL and MariaDB, SQL Server, Oracle, one product eachfrom 69.95 USD a year for MySQL
Redgate SQL Docthe databaseHTML, PDF, Word, MarkdownSQL Server303 USD per user a year
SchemaSpythe database, over JDBCHTML siteany with a JDBC driverfree, LGPL-3.0
Dataedothe database, into its repositoryweb portal; HTML, PDF, Excelrelational, MongoDB, Snowflake, BigQuery and moreEssentials, 18,000 USD a year
dbdocs.ioa DBML filehosted web pagePostgreSQL, MySQL, SQL Server, Snowflake, BigQuery through db2dbmlFree plan, up to 10 projects
Navicatthe databasePDF data dictionarythe engines of each Navicat productStandard and Enterprise
MySQL Workbencha Workbench modelHTML, textMySQLcommercial editions

Tools that generate documentation

DbSchema

DbSchema connects to the database, reverse-engineers the schema (reads its tables and keys into a diagram), and writes the documentation from that model:

  1. Connect to the database. DbSchema reads the tables, keys and existing comments.
  2. Double-click a table header on the diagram, type the description in the Comment tab, and press OK. While DbSchema is connected, OK also writes the comment to the database.
  3. Choose File → Export As... → HTML5/PDF Documentation, or press Ctrl+D.
  4. Type a Title, choose HTML5, PDF or Markdown under Format, and press Generate.
The Schema Documentation dialog in DbSchema with the title Shop Database, the format HTML5, Table of Contents ticked and the file path C:/docs/shop/index.html

Generating the documentation only reads the model. The HTML5 documentation is one .html file that opens in any browser, with no server and no internet connection. It carries the diagram as a vector image, shows each comment when you point at a table or column, and has a search box for tables, columns and comments. Below the diagram, each table gets a card with its columns, indexes and foreign keys:

The customers table in DbSchema's HTML5 documentation: its comment, its columns with data types and constraints, its indexes and the foreign keys that reference it

The site has samples of each format: the HTML5 page and the PDF. Markdown goes next to your code in a Git repository, with the diagram as an .svg image.

DbSchema checks the model after every change, in every edition. One of the checks flags a table with no comment. To refresh the documentation every night, generate it from a Groovy script.

DbSchema Pro documents any diagram. The free Community Edition documents a diagram of up to 12 tables, with "DbSchema Trial" across the diagram image. Saving the model to a file needs Pro as well.

dbForge Documenter

dbForge Documenter by Devart reads the database and writes HTML, PDF and Markdown. Each engine has its own product: one for MySQL and MariaDB, one for SQL Server and one for Oracle. You edit object descriptions in Documenter, and the SQL Server edition reads them from extended properties. A command-line interface runs the generation from a script or Windows Task Scheduler.

The MySQL product starts at 69.95 USD a year, and the SQL Server product at 189.95 USD a year. dbForge runs natively only on Windows; on Linux and macOS, the requirements page asks for CodeWeavers CrossOver.

Redgate SQL Doc

Redgate SQL Doc documents SQL Server databases as HTML, PDF, Word or Markdown files. You add descriptions in SQL Doc, and it keeps them as extended properties in the database. A one-year subscription costs 303 USD per user for one to four users, and the trial lasts 14 days.

SchemaSpy

SchemaSpy is a free command-line program under the LGPL-3.0 license. It needs Java and the JDBC driver of your database. SchemaSpy reads the schema and writes an HTML site with ER diagrams. It prints the comments it finds in the database, and an XML file can add comments where the database has none. The latest release on GitHub is 7.0.2, from September 2025.

Dataedo

Dataedo is a data catalog. It imports the schema into its own repository, a database that Dataedo manages, and keeps the descriptions there. Its Windows desktop app exports HTML, PDF and Excel, and its web portal serves the catalog to readers. Dataedo's list of database connectors includes MongoDB, Snowflake and BigQuery. Dataedo also keeps a business glossary, the definitions of business terms, and data lineage, which shows where each table's data comes from. The Essentials plan costs 18,000 USD a year. Each plan needs at least three editors, viewers are unlimited, and the trial lasts 14 days.

dbdocs.io

dbdocs.io publishes a web page from a DBML file, the text format of dbdiagram.io. The descriptions live in that file, next to your code. The db2dbml command writes the DBML from a PostgreSQL, MySQL, SQL Server, Snowflake or BigQuery database. On the pricing page, the Free plan publishes up to 10 projects without password protection, and Personal Pro costs 8 USD a month.

Navicat's Data Dictionary writes a PDF that lists the database objects, laid out by a template that you can change. On the feature matrix, the Data Dictionary and its schedule are in the Standard and Enterprise editions, and not in the free Lite edition. Navicat runs on Windows, macOS and Linux.

MySQL Workbench

MySQL Workbench writes HTML or text reports from a Workbench model with DBDoc, its report generator. The MySQL Workbench manual says DBDoc "is only available in the MySQL Workbench Commercial Editions". Workbench covers MySQL only. MySQL's product page says that the new MySQL Workbench replaces the earlier releases, such as 8.0, which have reached end of life.

An EER diagram in MySQL Workbench, drawn from a Workbench model

DbSchema documents MySQL as it documents any other database: up to 12 tables per diagram in the free Community Edition, and any diagram in DbSchema Pro.

Database clients that show a schema without documenting it

A database client shows the schema to someone who has it open. Each of the clients below draws a diagram and exports data, but none writes documentation of the schema.

DataGrip

DataGrip by JetBrains is free for non-commercial use, and commercial use needs a subscription. It exports a diagram as a PNG image, or as a file for yEd, draw.io, Graphviz, Mermaid or PlantUML. With a non-commercial license, the data-sharing consent cannot be switched off.

DBeaver

DBeaver Community is free under the Apache 2.0 license. It draws an ER diagram from a live connection and saves it as PNG, GIF, BMP or GraphML, with SVG in the paid editions. On the editions page, Lite costs 113 USD a year, Enterprise 255 USD and Ultimate 510 USD.

An ER diagram in DBeaver Enterprise 25.0.0, drawn from a live PostgreSQL connection

HeidiSQL

HeidiSQL is a free client for MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, among others. It runs on Windows, Linux and macOS, with a portable build for Windows. It exports table rows as HTML, Markdown and other formats, and the database as an SQL script.

Document your own schema

Download DbSchema and connect it to the database that your colleagues keep asking about. Type a comment on the tables that need one, then export the HTML5 documentation and send them the file. The free Community Edition connects, reverse-engineers and documents a diagram of up to 12 tables. DbSchema Pro documents any diagram and saves the model to a file, and the download starts with a 15-day trial of every paid feature.

Sources

  1. DbSchema: schema documentation
  2. DbSchema: model validation
  3. DbSchema: automation scripts
  4. Microsoft: sp_addextendedproperty
  5. dbForge Documenter for MySQL
  6. dbForge Documenter for SQL Server
  7. dbForge Documenter for Oracle
  8. dbForge Documenter for MySQL: requirements
  9. Redgate SQL Doc
  10. SchemaSpy on GitHub
  11. Dataedo pricing
  12. Dataedo Desktop
  13. Dataedo: databases
  14. dbdocs.io
  15. dbdocs: generate DBML from a database
  16. dbdiagram.io and dbdocs pricing
  17. Navicat Premium feature matrix
  18. Navicat: create a data dictionary in Navicat 17
  19. MySQL Workbench manual: DBDoc
  20. MySQL Workbench
  21. DataGrip: diagrams
  22. DataGrip: usage statistics
  23. DBeaver: ER diagrams
  24. DBeaver editions
  25. HeidiSQL

Generate documentation from your own schema

DbSchema reverse-engineers the database into a diagram and exports HTML5, PDF and Markdown documentation from the same model. The free Community Edition documents a diagram of up to 12 tables; DbSchema Pro documents any diagram.