Data Relational Database

Purpose

Design relational database schemas with proper indexing, partitioning, replication, connection pooling, and query optimization strategies.

Agent Protocol

Trigger

Exact user phrases: "PostgreSQL", "MySQL", "relational database", "partitioning", "replication", "indexing", "vacuum", "connection pooling", "query optimization", "EXPLAIN", "CTE", "window function", "transaction isolation", "migration", "PgBouncer", "MVCC", "WAL", "B-tree", "GiST", "GIN", "BRIN".

Input Context

Before activating, verify:

• Database platform (PostgreSQL, MySQL, MariaDB, SQLite)
• Data volume (rows, growth rate, total size in GB/TB)
• Query workload (OLTP, OLAP, mixed)
• Current schema and migration tool (Alembic, Sqitch, Flyway, Liquibase)
• Existing indexing strategy and planner statistics
• Replication needs (read replicas, disaster recovery, logical replication)
• Connection pooling requirements (client count, max connections)