# 6. Auto-Catalog

Machine-generated, exhaustive reference for every database object in
the deployed schema.

This chapter is regenerated by `scripts/gen_catalog.py`, which queries
the live database directly through `~/.my.cnf`. **Do not hand-edit
pages under this chapter** — they will be overwritten on the next
regeneration. Hand-written narrative belongs in
[Reference](../reference/builder/index.md) or
[Vertical Slices](../slices/index.md), with cross-links from here.

- [Tables](tables/index.md) — every base table.
- [Views](views/index.md) — every view, with its `CREATE VIEW` body.
- [Procedures](procedures/index.md) — every stored procedure, with its parameter list.
- [Functions](functions/index.md) — every stored function, with its parameter list and return type.

Each entry includes name, comment, columns / parameters, indexes (for
tables), the `CREATE VIEW` body (for views), and a narrative slot for
any human-written prose that covers it.

To regenerate: `python scripts/gen_catalog.py`. The script reads
connection parameters from `~/.my.cnf` and the schema name from the same
file's `database = ...` entry; override either via the `DB_DEFAULTS_FILE`
or `DB_NAME` environment variables.