SQL & Databases Agent Skills

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

Diagnoses Qdrant production issues using metrics and observability tools, covering optimizer problems, memory spikes, and slow queries.

Compare identical tables across two SQL Server instances using Python with mssql-python and Apache Arrow, detecting missing rows, column mismatches, schema drift, and generating a reconciliation report.

Generate production-ready Python code using the Dataverse SDK with error handling, retry logic, OData optimization, and logging.

Translates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL, preserving method signatures and type-anchored parameters while applying Oracle-compatible sorting and leveraging orafce.

Store and query embeddings with metadata filtering, vector search, and full-text search using an open-source database that scales from notebooks to production.

Tracks institutional investor ownership changes and portfolio flows using 13F filings data to identify stocks with significant smart money accumulation or distribution.

Manages SurrealDB schemas as desired-state .surql files, with sync for disposable databases and reviewed rollouts for shared or production environments, plus seeding and declarative testing.

Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls, including index tuning recommendations, query plan analysis, health monitoring, and schema intelligence.

Installs the official MongoDB Node.js driver and verifies package integrity for building MongoDB-backed applications.

Design schemas, write TypeScript functions, and manage real-time subscriptions, auth, file storage, scheduling, and deployment for Convex backends.

Administra bases de datos PostgreSQL, MySQL, Redis y SQLite: diseña esquemas, optimiza queries, configura migraciones, replicación y backups.

Connect to PostgreSQL, MySQL, SQLite, and SQL Server databases using SQLAlchemy, Pandas, and DuckDB. Read and write tables, manage sessions, and handle connection strings securely.

Design schemas, write TypeScript queries/mutations/actions, and set up real-time subscriptions, auth, file storage, scheduling, and deployment for Convex backends.

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

Quick reference for PostgreSQL best practices covering indexing, schema design, query optimization, and security defaults.

Ingests music into a LanceDB via ncmdump-rs and sf-cli, searching and downloading from Netease Cloud Music or Bilibili, decrypting local NCM files, and extracting metadata, lyrics, and cover art.

Pulls pathway, book, course, article, and content item records from a Supabase database for the alan-hirsch tenant, organizes them by portal, and exports the results as markdown files into a local docs repository.

Runs SQL queries and data conversions on CSV, Parquet, and JSON files using the DuckDB command-line interface, including schema inspection and output formatting.

Provides a discovery stub for the Wren CLI, a semantic SQL layer over 22+ databases, with commands to install, set up, connect data sources, generate MDL projects, enrich context, and deploy GenBI dashboards.

Access 83 unified crypto data endpoints covering CEX/DEX markets, on-chain SQL across 80+ blockchain tables, wallet labels, prediction markets, social intelligence, news, and DeFi metrics via a local HTTP API with per-call billing.

Perform fast genomic interval operations (overlap, nearest, merge, coverage, cluster, complement, subtract, count-overlaps), multi-format bioinformatics I/O, DataFusion SQL, and pileup on Polars DataFrames via the polars-bio library, serving as a scalable alternative to bioframe and bedtools.

Provides guidance and best practices for working with Cassandra, covering setup, configuration, development, deployment, and operations.

Covers MariaDB-specific behavior of the mariadb command-line client, including batch mode output, delimiter handling, safe-updates, charset detection, and TLS defaults, for writing or reviewing shell commands and scripts.

Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.

Covers MariaDB-specific ALTER USER and SET PASSWORD syntax, including IF EXISTS semantics, authentication methods, password expiration, account locking, and resource limits.

Explains MariaDB explicit table locking (LOCK TABLES/UNLOCK TABLES) and named user-level locks (GET_LOCK family), covering alias traps, implicit commits, and multi-lock semantics for writing or reviewing locking code.

Generates and reviews MariaDB CREATE SEQUENCE statements with version-specific syntax, defaults, and gotchas.

Reference for MariaDB window functions and the OVER clause, covering ranking, value navigation, and ordered-set functions with syntax and common pitfalls.

Browse and inspect MariaDB REST Service objects using read-only SHOW REST and SHOW CREATE REST statements to list services, schemas, views, procedures, functions, content sets, auth apps, roles, grants, and dump DDL for reverse-engineering or auditing.

Covers MariaDB-specific behavior of the Connector/C++ sql:: API, including driver and connection setup, 1-based indexes, placeholder syntax, ResultSet iteration, raw pointer ownership, SQLString, autocommit, and exception handling.

Reference for MariaDB's built-in encryption, hashing, and compression functions, covering AES_ENCRYPT/DECRYPT, SHA2, KDF, COMPRESS, and related functions, with guidance on correct usage and common pitfalls.

Provides a SQLite-backed persistence layer for skill execution metrics, feedback, improvement candidates, and version history, with query and maintenance workflows.

Syncs key-value preferences and state across multiple agents using a shared TiDB Zero database, with optional auto-provisioning of a free ephemeral database.

Build Cloudflare D1 schemas and queries with Drizzle ORM, including migrations, relations, and batch operations.

Analyzes TiDB cluster topology, slow queries, hot regions, and SQL performance using read-only database and API queries.