SQL & Databases Agent Skills

Designs Elasticsearch indexes and mappings, tunes queries, sizes clusters, and handles operations like shard/replica strategy, ILM, monitoring, troubleshooting, and safe reindexing or upgrades.

Executes MySQL database development and review tasks based on user-provided rules, covering naming constraints, index design, and data archiving for large datasets.

Generates SQL queries against a custom database schema (Vika/Airtable-like) to look up table names, dst_ids, records, and field metadata.

Extracts a specified URL parameter (such as loc) from a MySQL text column, derives the domain from each parameter value, and counts occurrences per domain, sorted descending.

Installs the Snowflake Connector for Python and builds a wheel package using PEP-517.

Analyze SQLite databases using the better-sqlite3 Node.js library, including querying, inserting, and iterating over rows.

Sets up a Node.js project to use the AWS SDK for JavaScript v3 and make DynamoDB service calls.

Provides a quick start guide to Redis, including installation via Docker, building from source, and links to client libraries for Python and JavaScript.

Runs MySQL queries from an AI coding agent using the mysql2 Node.js library, with setup instructions for npm and TypeScript.

Provides a lightweight local SQLite database access layer for AI agents via an MCP server, with installation and usage guidance.

Write and run analytical SQL queries against Redpanda SQL (Oxla), a distributed PostgreSQL-wire-compatible columnar database, including data loading, external sources, and type handling.

Manage schemas, subjects, compatibility levels, modes, and contexts in the Redpanda Schema Registry via the rpk registry CLI. Register or fetch Avro, Protobuf, and JSON schemas, set compatibility levels, change registry mode, and work with schema contexts.

Streams change data capture from Oracle Database into Redpanda or Kafka using the oracledb_cdc input in Redpanda Connect, which reads redo logs via LogMiner. Covers configuration, Oracle setup, checkpointing, and enterprise features.

Streams change data capture from MongoDB into Redpanda or Kafka using Redpanda Connect's mongodb_cdc input, covering Change Streams, snapshots, document modes, and resume-token checkpointing.

Streams change data capture from PostgreSQL into Redpanda or Kafka using Redpanda Connect's postgres_cdc input, covering setup, snapshotting, and troubleshooting.

Streams change data capture from Microsoft SQL Server into Redpanda or Kafka using Redpanda Connect's microsoft_sql_server_cdc input, covering setup, configuration, and troubleshooting.

Streams change data capture events from a TigerBeetle financial transactions database into Redpanda or Kafka using the tigerbeetle_cdc input, with checkpointing, filtering, and routing guidance.

Maps the Salesforce CPQ managed-package object graph (SBQQ__ namespace) and explains when to use the CPQ Quote API for programmatic writes instead of direct DML.

Explains the Financial Services Cloud data model, covering managed-package and Core FSC object structures, household relationships, financial account ownership, and the rollup framework, with SOQL query patterns.

Understand and query the NPSP data model, including namespace prefixes, GAU allocations, recurring donations, relationships, and affiliations.

Enables, configures, and troubleshoots Salesforce Person Accounts, covering data model design, IsPersonAccount flag handling, reporting impact, migration planning, and integration requirements.

Write and debug SOQL queries covering SELECT syntax, filters, sorting, pagination, relationship traversal, and aggregate functions.

Guides composing SOSL FIND queries with result-scoping or result-shaping WITH clauses, covering clause order, supported objects, field-type limits, and API-version floors.

Write SOQL queries that group or filter records by date periods using the 13 SOQL date functions, with rules for WHERE vs GROUP BY placement, date-literal comparisons, and fiscal-year restrictions.

Provides guidance on using the Astropy library for astronomy and astrophysics workflows, including units, coordinates, FITS I/O, tables, time, WCS, and cosmology.

Analiza datos en bases de datos relacionales con consultas SQL eficientes y legibles, incluyendo joins, window functions, CTEs y subqueries, para extraer insights directamente de la base de datos.

Analyze Claude Code token usage, spending, and budgets from a local SQLite cost-tracking database, with breakdowns by project, tool, session, or date.

Interact with Airtable bases, tables, and records via the REST API using curl commands, covering CRUD operations, filtering, sorting, pagination, and upserts.

Search, read, create, update, and delete blocks and documents in a self-hosted SiYuan knowledge base via its kernel API using curl.

Guides backup, restore, snapshot, PITR, retention, and disaster recovery planning for PostgreSQL and AWS, emphasizing tested restores and RTO/RPO alignment.

Executa consultas, inspeção de schema e mutações seguras (DML/DDL com dry-run) no PostgreSQL via servidor MCP, exigindo confirmação explícita para alterações.

Generates one-day Kiro credit usage reports from LanceDB usage events, with China-time windows, global totals, and account subset breakdowns.

Publishes Markdown articles and images into LanceDB via the sf-cli tool, syncs notes, infers missing metadata, and verifies results with local API checks.

Upserts a validated MDX book corpus into Supabase via Drizzle, hydrating books, chapters, sections, and chunks tables while preserving stable bookmark anchors and only re-embedding changed content.

Teaches standard SQL for creating, managing, and querying relational databases, covering DDL, DML, DQL, DCL, joins, subqueries, and best practices.

Create and manage ODB databases, connect to external databases, and automate forms, reports, and data operations with LibreOffice Base.