# Sqlite Schema Report

> Vendor-neutral skill to summarize a SQLite database schema (tables, columns, indexes, foreign keys) and emit a portable report.

- Skill: `sisodiabhumca/sqlite-schema-report` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add sisodiabhumca/sqlite-schema-report`
- Raw SKILL.md: https://api.skillmd.com/api/skills/sisodiabhumca/sqlite-schema-report/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: sisodiabhumca (https://skillmd.com/u/sisodiabhumca)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/sisodiabhumca/sqlite-schema-report

---


## When to invoke
- You received a SQLite database file and need a quick schema overview.
- You want to document a local database before migrating or integrating.

## Inputs needed
- `--db` path to a SQLite database.
- Optional: `--tables` comma-separated list of tables (default: all user tables).

## Workflow
1. Open database in read-only mode.
2. Discover user tables.
3. For each table, capture columns/types, indexes, and foreign keys.
4. Emit a JSON report.

## Output format
- JSON written to `--output`.

## Guardrails
- Read-only: never modify the database.
- Do not infer semantics beyond the declared schema.

## Reference code
- `sqlite_schema_report.py` uses Python stdlib `sqlite3`.