# Can the schema be easier to understand without losing depth?

Prompt · Schema and dependencies · PG12

New developers or agents keep misunderstanding names, concepts or relationships.

## Prompt

```text
Review the database's logical organization from the perspective of a new senior engineer. Identify confusing names, mixed responsibilities, inconsistent conventions, unclear relationships and schemas that obscure the business domain. Recommend structural improvements that make the model easier to understand and maintain without sacrificing useful historical detail or creating unnecessary migrations.
```

**What it returns:** The specific confusions, the work they affect, a schema map, and the least disruptive naming or boundary fixes.

**Skip it when:** Nobody has misread the schema recently.

**Avoid:** Cosmetic renames and broad migrations with no shown maintenance benefit.

**Tools:** Needs: the repository and read-only database access. Helps: declarative schema files, if the project uses them.

**Works on:** Any PostgreSQL host: Supabase, Neon, RDS, Cloud SQL or self-hosted.

**Changes:** Changes nothing

**Sessions:** Look first, then fix in a new session

## Related

- [Meaning drift across the stack](https://www.atlasscope.dev/prompts/meaning-drift-across-the-stack): Shows where one word (a task, a fund, a run) means slightly different things in different parts of the app.
- [Out-of-date agent instructions](https://www.atlasscope.dev/prompts/out-of-date-agent-instructions): Finds instructions that send agents to files and patterns that no longer exist.
- [Which database objects no longer earn their keep?](https://www.atlasscope.dev/prompts/which-database-objects-no-longer-earn-their-keep): The list of views, functions and triggers has grown hard to reason about.
- [Are we storing the same truth multiple times?](https://www.atlasscope.dev/prompts/are-we-storing-the-same-truth-multiple-times): Caches, aggregates, materialized views or derived columns drift from the raw facts.

Source: https://www.atlasscope.dev/prompts/can-the-schema-be-easier-to-understand-without-losing-depth