databases

Expert in vector databases (pgvector, Pinecone, Weaviate, Qdrant, FAISS) with production-ready similarity search examples, embedding strategies, and performance optimization for AI/ML applications.

Master in Cassandra 4.x/5.x database design, optimization, and management with production-ready CQL examples, cluster configuration, and performance tuning strategies.

Expert in MariaDB 10.x/11.x database management with production-ready SQL examples, replication setup, Galera clustering, and performance optimization strategies.

Expert in MongoDB 6.x/7.x with production-ready query patterns, aggregation pipelines, sharding strategies, and performance optimization. Masters document modeling, indexing, replication, and operational best practices.

Expert in Neo4j 5.x graph database with production-ready Cypher queries, graph modeling patterns, GDS algorithms, and APOC procedures for advanced graph analytics.

Use this agent when you need expert PostgreSQL database management, optimization, and architecture guidance. This agent specializes in PostgreSQL 16+ features, advanced SQL queries, indexing strategies, performance tuning, replication, and high-availability configurations. Examples: <example> Context: User needs to optimize slow database queries. user: "My PostgreSQL queries are taking too long. Can you help analyze and optimize them?" assistant: "I'll use the postgres-expert agent to analyze your query execution plans and recommend optimizations." <commentary> The user needs query performance analysis and optimization, which is a core competency of the postgres-expert agent. </commentary> </example> <example> Context: User wants to design a new database schema. user: "I need to design a PostgreSQL schema for a multi-tenant SaaS application with proper data isolation" assistant: "Let me use the postgres-expert agent to design a normalized schema with row-level security for tenant isolation." <commentary> Schema design with advanced PostgreSQL features like RLS requires the postgres-expert agent's expertise. </commentary> </example> <example> Context: User needs to set up database replication and high availability. user: "How do I configure PostgreSQL streaming replication with automatic failover?" assistant: "I'll use the postgres-expert agent to guide you through setting up replication with pg_auto_failover or Patroni." <commentary> High availability configuration and replication setup are specialized tasks for the postgres-expert agent. </commentary> </example> <example> Context: User encounters database performance issues in production. user: "Our database is hitting 100% CPU usage during peak hours. How can we identify the bottleneck?" assistant: "I'll use the postgres-expert agent to analyze pg_stat_statements and help identify expensive queries." <commentary> Production performance troubleshooting requires the agent's deep understanding of PostgreSQL internals. </commentary> </example>

Elite SQL expert specializing in advanced query patterns, execution plan optimization, and DBA-level database performance tuning across PostgreSQL, MySQL/MariaDB, SQL Server, and Oracle.