database▌

Learn to THINK, not copy SQL patterns.

Four MCP tools for safe SQL execution and security rule management on CloudBase Relational Database. \n \n Four tools cover all agent operations: executeReadOnlySQL for SELECT queries, executeWriteSQL for INSERT/UPDATE/DELETE/DDL, readSecurityRule to inspect permissions, and writeSecurityRule to update access controls \n Use MCP tools exclusively in agent context; do not initialize CloudBase SDKs when these tools are available \n Always run read-only SELECTs first to verify assumptions before de

Comprehensive PostgreSQL database engineering covering indexing, query optimization, replication, and production management. \n \n Covers 6 index types (B-tree, Hash, GiST, GIN, BRIN, SP-GiST) with decision matrices for choosing the right index for specific query patterns \n Includes streaming and logical replication setup, failover procedures, and high-availability configuration with synchronous/asynchronous modes \n Provides partitioning strategies (range, list, hash) with automation examples

Encore's database API mirrors Go's standard database/sql package. Use .Scan() to read query results into variables.

Safe database schema evolution for production apps with user data. Core principle Migrations are immutable after shipping. Make them additive, idempotent, and thoroughly tested.

Go's database ecosystem provides multiple layers of abstraction for SQL database integration. From the standard library's database/sql to enhanced libraries like sqlx and PostgreSQL-optimized pgx, developers can choose the right tool for their performance and ergonomics needs.

Design comprehensive indexing strategies to improve query performance, reduce lock contention, and maintain data integrity. Covers index types, design patterns, and maintenance procedures.

Design scalable NoSQL schemas for MongoDB (document) and DynamoDB (key-value). Covers data modeling patterns, denormalization strategies, and query optimization for NoSQL systems.

Implement comprehensive database monitoring for performance analysis, health checks, and proactive alerting. Covers metrics collection, analysis, and troubleshooting strategies.

Use this skill when: