Database Schema Documentation

This generates comprehensive database schema documentation with ERD diagrams, table definitions, and data dictionaries. You'd reach for it when onboarding developers to an existing schema, documenting a new database design, or creating reference material for table relationships and constraints. It covers the essentials like foreign keys, indexes, JSONB field structures, and enum types, with Mermaid diagram integration for visual ERDs. The structure separates overview docs from detailed table references, which works well for schemas with more than a handful of tables. One thing: it assumes you want PostgreSQL-style documentation, though the pattern adapts to other databases easily enough.

skills.sh installs: 576
GitHub stars: 379
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill database-schema-documentation --agent claude-code

Installs into .claude/skills of the current project.

Files

Overview

Create comprehensive database schema documentation including entity relationship diagrams (ERD), table definitions, indexes, constraints, and data dictionaries.

When to Use

Database schema documentation
ERD (Entity Relationship Diagrams)
Data dictionary creation
Table relationship documentation
Index and constraint documentation
Migration documentation
Database design specs

Quick Start

Minimal working example:

# Database Schema Documentation

**Database:** PostgreSQL 14.x
**Version:** 2.0
**Last Updated:** 2025-01-15
**Schema Version:** 20250115120000

## Overview

This database supports an e-commerce application with user management, product catalog, orders, and payment processing.

## Entity Relationship Diagram

SKILL.md on GitHub