{"id":46844452,"title":"Show HN: Drizzle-docs-generator – Generate database docs from Drizzle schemas","points":1,"user":"rikeda71","time":1769933506,"time_ago":"9 hours ago","type":"link","content":"

Hey HN,

I've been maintaining drizzle-docs-generator, a CLI tool that auto-generates \ndatabase documentation from Drizzle ORM schemas. We just released v0.6.0 with \nsome nice improvements, and I wanted to share it with the community.

## What it does:

- Generates DBML and Markdown documentation directly from your Drizzle schema

- Automatically extracts JSDoc comments and includes them in the docs

- Creates beautiful Mermaid ER diagrams

- Supports PostgreSQL, MySQL, and SQLite

- Works with both Drizzle v0 (relations API) and v1 (defineRelations)

## Recent improvements (v0.5.0 → v0.6.0):

- *Auto-relation detection*: No config needed – it finds foreign keys automatically

- *Markdown is now default*: Better user experience for most use cases

- *Nullable foreign keys*: Properly visualized in ER diagrams

- *Flexible ER diagrams*: New --no-columns flag to exclude columns when needed

- *Better coverage*: Improved test coverage from 60% → 80%+

## Why I built this:

Drizzle makes schema definition so smooth in TypeScript, but keeping docs in \nsync is painful. This tool lets your schema be the source of truth.

## Quick example:

```bash\nnpx drizzle-docs generate ./src/db/schema.ts -d postgresql\n```

Outputs organized markdown docs with an ER diagram automatically.

## Links:

GitHub: https://github.com/rikeda71/drizzle-docs-generator

NPM: https://www.npmjs.com/package/drizzle-docs-generator

Examples: https://github.com/rikeda71/drizzle-docs-generator/tree/main...

Would love feedback from folks using Drizzle! Are there features you'd like to\nsee? What pain points in your workflow could this help with?

MIT licensed, happy to discuss the architecture and challenges we solved.","url":"https://github.com/rikeda71/drizzle-docs-generator","domain":"github.com","comments":[],"comments_count":0}