SQL & Databases Agent Skills

Best practices for MariaDB system-versioned (temporal) tables, covering creation, querying historical data, managing history growth, and handling ALTER TABLE operations.

Develop the next version of a MariaDB Schema Management (MSM) schema by editing the development script and splitting large sections into SOURCE-included files.

Enforces SQL quality gates after every implementation: lint with SQLFluff, validate migrations with Flyway or Liquibase, and run database tests with pgTAP or equivalents.

Create, manage, and automate LibreOffice Base databases, including forms, reports, and data operations.

Generates a comprehensive, editable schema reference file for a data warehouse, including table metadata, row counts, and codebase context, to enable instant concept-to-table lookups.

Runs R statistics analyses on local datasets, producing NLSS-format tables, narratives, and JSONL logs from CSV, SAV, RDS, RData, or Parquet files.

Manages and analyzes Azure SQL databases via Azure CLI, covering DTU/vCore performance, elastic pools, geo-replication, and health monitoring.

Manages Neon serverless Postgres databases via the neonctl CLI and Neon API, covering projects, branches, databases, roles, endpoints, and compute scaling with a discovery-first workflow.

Manages Xata serverless databases via the xata CLI and REST API, covering discovery of workspaces, databases, branches, tables, schema, migrations, and record counts with read-only operations.

Points developers to the canonical WordPress Presence API sources and explains its ephemeral-table-plus-TTL architectural pattern, so they avoid inventing postmeta-based presence implementations.

Guides database index selection, creation, and maintenance with SQL examples for PostgreSQL and MySQL.

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Configures PostgreSQL replication including streaming, logical, cascading, delayed, failover, connection pooling, and backup with point-in-time recovery.

Provides SQL window function examples for ranking, aggregation, lag/lead, value extraction, frame specifications, and advanced analytics.

Manage Cloudflare D1 SQLite databases and KV key-value stores with setup commands, TypeScript usage patterns, and a decision matrix for choosing between them.

Guides setting up Drizzle ORM with Vercel Postgres and Vercel KV for a manufacturing analysis app, covering schema definition, queries, migrations, caching, sessions, and rate limiting.

Build on-chain relational databases on Solana using IQ Labs' IQDB, hanLock, and x402 tools, including CRUD operations, tamper-evident rolling hashes, password-based encoding, and payment-gated file inscription.

Provides guidance for using the Astropy Python library in astronomical research, covering coordinates, units, FITS files, cosmology, tables, time, and WCS transformations.

Provides expert guidance on modern SQL, cloud-native databases, query optimization, performance tuning, and data modeling for OLTP/OLAP workloads.

Guides database design, implementation, optimization, migration, pipeline development, quality, and operations across SQL and NoSQL platforms.

Optimize SQL queries, design database schemas, and tune performance across cloud-native and hybrid OLTP/OLAP environments.

Guides database design, implementation, optimization, migrations, data pipelines, and operations across SQL and NoSQL platforms.

Search and analyze conversation history stored in session JSONL files using jq and shell commands.

Write, review, debug, test, or optimize pandas Series, DataFrame, Index, groupby, merge, reshape, dtype, missing-value, and time-series code.

Write, review, debug, or test Python code that parses, inspects, transforms, builds, qualifies, optimizes, formats, or transpiles SQL with SQLGlot.

Write, review, debug, or interpret Python statistical models using statsmodels, including formulas, regression, GLM, time series, robust covariance, diagnostics, prediction intervals, and inference.

Query the Clever Data API to retrieve information about contacts, districts, schools, sections, students, and teachers across 44 read-only endpoints.

Deploys Weaviate vector database with hybrid search, modules, and GraphQL API.

Manage datasets, tables, and jobs in BigQuery. Run SQL queries, manage BigQuery resources, and perform basic data ingestion and analysis.

Provides guidance on using Neon Serverless Postgres, including setup, connection methods, features like branching and autoscaling, and references to official documentation.

Generates Python code using BigQuery DataFrames (BigFrames), the pandas/scikit-learn-style API over BigQuery, for dataframe and ML workflows.

Analyzes the downstream impact (blast radius) when a BigQuery table or view is broken, stale, or modified, identifying all affected downstream tables, dashboards, and processes.

Guides monitoring and observability setup for Qdrant vector search deployments, including Prometheus scraping, health checks, and metric-based debugging of production issues.

Generate D2 database diagrams from Entity Framework Core models by analyzing DbContext, entities, Fluent API, and migrations.

Capture application requirements and access patterns to design Azure Cosmos DB NoSQL data models using best practices and common patterns.