- Home
- Database Documentation Tools
- LLMSchema
LLMSchema
What it is
LLMSchema generates Markdown database-schema documentation for LLMs and AI agents. It extracts schemas from PostgreSQL, MySQL, and SQLite, documenting tables, columns, types, indexes, constraints, and relationships. By default, it produces one portable Markdown document; an alternate layout creates an overview and a separate file for each table. Users can select tables to include or exclude. The tool is available as a command-line program and a Go library, with installation instructions for Go and a quick install script for macOS and Linux. Its README suggests adding schema generation to a Makefile or migration script to keep the documentation current, then directing a coding agent to the files through AGENTS.md, CLAUDE.md, or an equivalent instruction file. LLMSchema is free, MIT-licensed, and self-hosted, with Linux, macOS, and Windows listed as platforms. The maker describes it as a development aid and cautions against relying on it for production-critical documentation. Views, materialized views, PostgreSQL triggers and functions, and table and column comments are listed as areas to explore.
For and against
For
- Supports PostgreSQL, MySQL, and SQLite.
- Outputs one document or per-table Markdown files.
- Can include or exclude selected tables.
- Available as a CLI tool and Go library.
- Free and MIT-licensed.
Against
- Maker cautions against production-critical documentation use.
- Views and materialized views are areas to explore.
- PostgreSQL triggers and functions are areas to explore.
The verdict
LLMSchema offers a free, self-hosted way to generate structured Markdown schema documentation for development work. Its maker specifically warns against relying on it for production-critical documentation.
Who it suits
LLMSchema suits developers who want Markdown schema references for AI-assisted coding with PostgreSQL, MySQL, or SQLite development databases. It is not presented as a source for production-critical documentation.
Plans and prices
Free (MIT-licensed software)
CLI and Go library · PostgreSQL, MySQL, SQLite
Read 8 Oct 2026 · github.com
On the record
- AI agent setup
- The README suggests telling a coding agent where the schema docs are located in AGENTS.md, CLAUDE.md, or an equivalent instruction file.github.com · read 8 Oct 2026
- Contribution and support
- The README invites contributions through issues and pull requests and suggests opening an issue first for larger features.github.com · read 8 Oct 2026
- Developer interface
- LLMSchema is available as a command-line tool and a Go library.github.com · read 8 Oct 2026
- Feature gaps
- The README lists views and materialized views, PostgreSQL triggers and functions, and table and column comments as areas to explore.github.com · read 8 Oct 2026
- Filtering
- Users can include selected tables or exclude tables from the generated documentation.github.com · read 8 Oct 2026
- Installation
- The README provides Go installation instructions and a quick install script for macOS and Linux.github.com · read 8 Oct 2026
- Integration
- The README shows adding schema generation to a Makefile or migration script to keep documentation up to date.github.com · read 8 Oct 2026
- Intended use
- The maker describes the tool as intended for development databases to support AI-assisted coding and says not to rely on it for production-critical documentation.github.com · read 8 Oct 2026
- Interfaces
- LLMSchema is available as a command-line tool and as a Go library.github.com · read 8 Oct 2026
- License
- The repository identifies the project as MIT licensed.github.com · read 8 Oct 2026
- Maker
- The repository is published under the GitHub account tordrt, whose profile name is Tord.github.com · read 8 Oct 2026
- Output
- It documents tables, columns, types, indexes, constraints, and relationships in Markdown.github.com · read 8 Oct 2026
- Output formats
- It can produce one portable Markdown document or an overview with a separate Markdown file for each table.github.com · read 8 Oct 2026
- Output options
- It writes one Markdown document by default and can optionally create an overview plus one file per table.github.com · read 8 Oct 2026
- Pricing and trial
- The README provides installation instructions without listing paid plans or a trial.github.com · read 8 Oct 2026
- Purpose
- LLMSchema generates database schema documentation for LLMs and AI agents.github.com · read 8 Oct 2026
- Schema details
- The generated documentation can include tables, columns, types, indexes, constraints, and relationships.github.com · read 8 Oct 2026
- Security and reliability limit
- The README says the tool is intended for development databases and should not be relied on for production-critical documentation.github.com · read 8 Oct 2026
