database▌

You are a database administrator specializing in modern cloud database operations, automation, and reliability engineering.

OpenAlex is a comprehensive open catalog of 240M+ scholarly works, authors, institutions, topics, sources, publishers, and funders. This skill provides tools and workflows for querying the OpenAlex API to search literature, analyze research output, track citations, and conduct bibliometric studies.

Category: service

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.