SQL & Databases Agent Skills

Retrieves and answers questions from a local knowledge base directory by navigating hierarchical index files, then progressively searching Markdown, PDF, and Excel files using grep, Read, pdfplumber, and pandas.

Provides JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

Provides ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Provides MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends.

Quick reference for Redis best practices across common backend use cases, including caching strategies, rate limiting, distributed locks, pub/sub, streams, and connection management.

Provides production patterns and non-obvious traps for Prisma ORM in TypeScript backends, covering schema design, query optimization, transactions, pagination, and common pitfalls.

Provides backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.

Quick reference for PostgreSQL best practices covering query optimization, schema design, indexing, Row Level Security, and connection pooling.

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

Design schemas, write TypeScript functions, set up real-time subscriptions, authentication, file storage, scheduling, and deployment for Convex reactive backend projects.

Perform astronomical research and data analysis with coordinate transformations, unit conversions, FITS file operations, cosmological calculations, time handling, and tabular data manipulation.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

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

Search, query, inspect, create, and import data into Weaviate vector database collections using official scripts and references.

Provides Python tools for biological computation, including sequence manipulation, file I/O, database access, structural bioinformatics, and phylogenetics.

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance patterns.

Translates natural language data intents into syntactically valid Perfetto SQL queries and executes them against a local trace file using trace_processor.

Optimize Entity Framework Core queries by fixing N+1 problems, choosing correct tracking modes, using compiled queries, and avoiding common performance traps.

Provides guidance for Oracle Database administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, and agent-safe database workflows.

Generates a compact KPI digest showing how key metrics changed over a period and what's driving the movement, using Customer Journey Analytics data.

Analyze CJA dimensions for cardinality, distribution, trends, anomalies, data quality, comparisons, and forecasting, producing an interactive HTML dashboard or markdown report.

Get best practices for Entity Framework Core, covering data context design, entity design, performance, migrations, querying, change tracking, security, and testing.

Generate XML configuration files and execute SSMA Console commands for Oracle to SQL Server database migration, including schema conversion and data migration.

Guides scaling decisions for Qdrant vector databases based on data volume, query throughput, latency, or query volume.

Performs comprehensive SQL code review across all major databases, analyzing security, performance, maintainability, and anti-patterns.

Design, build, and optimize Microsoft Fabric Lakehouse solutions with guidance on core concepts, components, security, shortcuts, and performance optimization.

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Integrate Qdrant vector search into applications using officially supported client SDKs for Python, JavaScript, Rust, Go, .NET, and Java.

Review PostgreSQL code for best practices, anti-patterns, and quality standards including JSONB, arrays, custom types, schema design, functions, and security features like Row Level Security.

Guides embedding model migration in Qdrant without downtime, covering alias swap, side-by-side, and hybrid search strategies.

Upgrade Qdrant version without interrupting application availability and ensuring data integrity.

Create, alter, and validate Snowflake semantic views using Snowflake CLI, including DDL drafting, validation, and querying.

Guides selection of Qdrant deployment options: local mode, Docker, self-hosted, Qdrant Cloud, Hybrid Cloud, or Qdrant EDGE based on latency, control, and production needs.

Guides scaling Qdrant query throughput (QPS) through performance tuning, horizontal scaling with read replicas, and disk I/O optimization.

Optimize Qdrant vector search performance through indexing strategies, query tuning, memory management, and hardware considerations.

Guides optimization of Qdrant query latency by tuning segments, memory, quantization, and search parameters.