Skip to content
Data & Database Review for AI Agents
The Trove library

Data & Database Review for AI Agents

Read a preview

You can read the contents and the first 2,000 characters.
Pro includes the whole book.

  • By Sahar Carmel
  • 21 chapters
  • Updated Oct 1, 2026

What’s inside

  • Schema Changes & Migrations
  • Query Shape & Indexing
  • SQL Correctness Antipatterns
  • Transactions, Isolation & Locking
  • Postgres & Supabase Platform
  • ORM & Data-Access Layer

What is Data & Database Review for AI Agents?

markdown · Listed Oct 1, 2026

  • code-review
  • database
  • sql
  • postgres
  • data-engineering
  • dbt
  • kafka
  • ai-agents

From the first page

This book is a lookup reference, not a narrative. It is for AI agents that review code which stores, moves, transforms or reports data. Do not read it from start to end during a review. Classify the diff, load only the chapters its files call for, and use the Master Decision Matrix (Chapter 2) to jump to rules.

Preview · 2,000 of 495,191 characters

PlanetScale Database Skills — The Complete Guide
Code Review for AI Agents
Supabase PostgreSQL Best Practices
OpenAI Prompting Best Practices

Contents

  1. 01Data & Database Review for AI Agentsp.1
  2. 02How to Use This Bookp.2
    1. Workflowp.2
    2. Severity Scalep.2
    3. Chapter Mapp.2
    4. File-Signal Loading Guidep.2
    5. Relation to the Parent Bookp.2
    6. Per-Chapter Structurep.2
    7. How to Report a Findingp.2
    8. Source Booksp.2
  3. 03Master Decision Matrixp.3
    1. Path 1: Pattern-Based — "I See This in the Code"p.3
    2. Path 2: Task-Based — "I'm Reviewing a PR That Does X"p.3
    3. Path 3: Severity-Based — Quick Filterp.3
    4. Cross-Book Map — Parent Rule to Companion Rulesp.3
  4. 04Schema Changes & Migrationsp.4
    1. Red Flag Tablep.4
    2. Rulesp.4
    3. Verificationp.4
    4. Common Mistakesp.4
  5. 05Query Shape & Indexingp.5
    1. Red Flag Tablep.5
    2. Rulesp.5
    3. Verificationp.5
    4. Common Mistakesp.5
  6. 06SQL Correctness Antipatternsp.6
    1. Red Flag Tablep.6
    2. Rulesp.6
    3. Verificationp.6
    4. Common Mistakesp.6
  7. 07Transactions, Isolation & Lockingp.7
    1. Red Flag Tablep.7
    2. Rulesp.7
    3. Verificationp.7
    4. Common Mistakesp.7
  8. 08Postgres & Supabase Platformp.8
    1. Red Flag Tablep.8
    2. Rulesp.8
    3. Verificationp.8
    4. Common Mistakesp.8
See all 21 parts
  1. 09ORM & Data-Access Layerp.9
    1. Red Flag Tablep.9
    2. Rulesp.9
    3. Verificationp.9
    4. Common Mistakesp.9
  2. 10Caching & Redisp.10
    1. Red Flag Tablep.10
    2. Rulesp.10
    3. Verificationp.10
    4. Common Mistakesp.10
  3. 11Replication, Events & Consistencyp.11
    1. Red Flag Tablep.11
    2. Rulesp.11
    3. Verificationp.11
    4. Common Mistakesp.11
  4. 12Batch Pipelines (ETL/ELT)p.12
    1. Red Flag Tablep.12
    2. Rulesp.12
    3. Verificationp.12
    4. Common Mistakesp.12
  5. 13dbt & Warehouse Modellingp.13
    1. Red Flag Tablep.13
    2. Rulesp.13
    3. Verificationp.13
    4. Common Mistakesp.13
  6. 14Orchestration: Airflow & Dagsterp.14
    1. Red Flag Tablep.14
    2. Rulesp.14
    3. Verificationp.14
    4. Common Mistakesp.14
  7. 15Spark & Large-Scale Batchp.15
    1. Red Flag Tablep.15
    2. Rulesp.15
    3. Verificationp.15
    4. Common Mistakesp.15
  8. 16Streaming: Kafka & Flinkp.16
    1. Red Flag Tablep.16
    2. Rulesp.16
    3. Verificationp.16
    4. Common Mistakesp.16
  9. 17Data Contracts, Quality & Schema Evolutionp.17
    1. Red Flag Tablep.17
    2. Rulesp.17
    3. Verificationp.17
    4. Common Mistakesp.17
  10. 18Metrics, Semantic Layer & Governance-in-Codep.18
    1. Red Flag Tablep.18
    2. Rulesp.18
    3. Verificationp.18
    4. Common Mistakesp.18
  11. 19Testing Data Codep.19
    1. Red Flag Tablep.19
    2. Rulesp.19
    3. Verificationp.19
    4. Common Mistakesp.19
  12. 20Reading Map for Data Engineering at Scalep.20
    1. 1. Large Companies: What Changes at Scalep.20
    2. 2. Team Structure: Central Platform, Embedded Teams, or Bothp.20
    3. 3. Data Mesh Versus a Central Warehousep.20
    4. 4. Modelling Strategyp.20
    5. 5. Storage: Warehouse, Lake, Lakehouse and Table Formatsp.20
    6. 6. Batch Versus Streamingp.20
    7. 7. Governed Self-Serve Analyticsp.20
    8. 8. Semantic Layer and Metric Definitionsp.20
    9. +9 more sections
  13. 21Appendices: False-Positive Guidance, Severity Overrides & Cheat Sheetp.21
    1. Section 1: "When NOT to Flag" Addendump.21
    2. Section 2: Severity Override Matrixp.21
    3. Section 3: Quick Reference Cheat Sheetp.21
    4. Section 4: File-Signal Loading Tablep.21
    5. Section 5: Source Booksp.21