metadata-intelligence 0.1.1

CLI tool that reads a database schema and generates documentation using an LLM.

metadata-intelligence

CLI tool that connects to a database (PostgreSQL, MySQL, SQL Server, Snowflake, Databricks, or MongoDB), reads the schema, and uses an LLM to generate documentation automatically. No frontend. No manual input beyond a one-time setup wizard.

Install

pip install metadata-intelligence[postgres]   # or [mysql] [sqlserver] [snowflake] [databricks] [mongodb] [all]

Run

metadata-intelligence

A wizard asks for your database type, connection details, LLM provider/key, and output folder on every run — nothing is read from or written to a .env file; answers live only in memory for that process.

Output

Generates data_dictionary.md, column_docs.json, an interactive ER diagram (er_diagram.html/.png/.mmd), pii_report.md, an Excel workbook (schema_documentation.xlsx), and Suggestion_Report.docx for suggested keys/relationships.

Known system dependencies

• SQL Server requires an ODBC driver installed on the OS (not pip-installable).
• PNG export via cairosvg requires libcairo2 on Linux (apt install libcairo2); Windows installs typically bundle this already.

License

MIT — see LICENSE.