Databases Agent Skills

Your approach to handling backend queries.

Analyzes PHP code for batch processing issues.

Use when seeing errors about better-sqlite3 native module, NODE_MODULE_VERSION mismatch, "was compiled against a different Node.js…

Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven…

Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness.

Manage Google Bigtable instances/tables, design schemas, and query data using SQL or client libraries.

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL…

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

Use when constructing an embedded buntdb (in-memory key/value store with optional persistence) via…

Use when constructing a Cassandra session via github.com/xgodev/boost/factory/contrib/gocql/gocql/v1.

Use when constructing a Google Firestore client in a Go service via github.com/xgodev/boost/factory/contrib/cloud.google.com/firestore/v1.

Use when connecting to Oracle DB from a Go service via github.com/xgodev/boost/factory/contrib/godror/godror/v0.

Use when constructing a hashicorp/go-memdb in-memory database (transactional indexed store) via…

Use when constructing a MongoDB connection in a Go service via github.com/xgodev/boost/factory/contrib/go.mongodb.org/mongo-driver/v1 or v2.

Use when constructing a PostgreSQL *sql.DB via github.com/xgodev/boost/factory/contrib/jackc/pgx/v5.

Use when a Go service needs the concrete implementation behind a domain port (repository / datastore / cache / provider) to be selectable…

Patterns for optimizing database query performance

Use when choosing, implementing, or reviewing browser storage such as localStorage, sessionStorage, IndexedDB, cookies, client…

Build a new Fivetran connector from a description.

Use framework caches and value/query caching to reduce work; add tags, locks, and explicit invalidation strategies for correctness

Caching Strategies knowledge base. Provides caching patterns (Cache-Aside, Read-Through, Write-Through, Write-Behind), invalidation…