SQL & Databases Agent Skills

Diagnoses Qdrant search quality issues by isolating causes like HNSW approximation, quantization, embedding model, or search pipeline problems.

Generate production-ready Dataverse SDK solutions with architecture recommendations, data models, and implementation code for common business use cases.

Guides scaling decisions for Qdrant vector databases when data volume exceeds single-node capacity, covering tenant scaling, time window rotation, vertical scaling, and horizontal sharding.

Optimizes Qdrant query performance for large limits across multiple shards by using Poisson-distributed subsampling to reduce inter-shard data transfer.

Systematically diagnose and resolve performance issues in Power BI models, reports, and queries using a structured troubleshooting methodology.

Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences. Use when planning a database migration, reviewing migration artifacts, or validating integration test coverage.

Guides selection of Qdrant search strategies including hybrid search, reranking, relevance feedback, MMR, and discovery APIs to improve retrieval quality.

Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan.

Guides scaling Qdrant for multi-tenant workloads using payload partitioning, custom sharding, and tiered multitenancy.

Guides vertical scaling decisions for Qdrant vector databases, covering when to scale up, how to resize nodes in Qdrant Cloud or self-hosted deployments, RAM sizing formulas, and when to switch to horizontal scaling.

Diagnoses Qdrant capacity needs and guides horizontal scaling decisions, including node count, shard count, replication factor, and resharding trade-offs.

Scaffolds an xUnit integration test project for validating Oracle-to-PostgreSQL database migration behavior in .NET solutions, including transaction-rollback base class and seed data manager.

Guides scaling Qdrant vector search with time-based data rotation using shard rotation, collection rotation, or filter-and-delete strategies.

Generates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations, producing DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems.

Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations, analyzing a project to identify repositories, DAOs, and service layers that interact with the database, then producing a structured testing plan.

Diagnoses and reduces Qdrant memory usage by analyzing resident memory, page cache, and providing optimization techniques like quantization, on-disk storage, and async_scorer.

Diagnoses and resolves slow Qdrant search performance issues including high latency, low throughput, and slow filtered searches.

Diagnoses and resolves slow Qdrant indexing and data ingestion by optimizing batching, sharding, HNSW parameters, and payload indexing strategies.

Read and query onchain data using events, The Graph, Dune, Ponder, Multicall3, and WebSocket subscriptions, with guidance on block iteration limitations.

Query NFT and token data, browse drops, stream events, and search across Ethereum, Base, Arbitrum, Optimism, Polygon, and more using the OpenSea API.

Automate Neon serverless Postgres operations: manage projects, branches, databases, roles, and connection URIs via the Composio MCP integration.

Automate Turso database operations through Composio's Turso toolkit via Rube MCP, with tool discovery and connection management.

Automate Prisma database operations through Composio's Prisma toolkit via Rube MCP, including tool discovery, connection management, and execution.

Automate Baserow database operations through Composio's toolkit via Rube MCP, with tool discovery and connection management.

Automate Bitquery blockchain data queries through Composio's Bitquery toolkit via Rube MCP, with dynamic tool discovery and connection management.

Manage customers, sales orders, invoices, inventory, and records in Oracle NetSuite ERP using SuiteQL queries and composio toolkits.

Automate Snowflake data warehouse operations: list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.

Automate financial data retrieval and analysis using Alpha Vantage via Composio's Rube MCP toolkit.

Run SQL queries, explore datasets and metadata, and execute MBQL queries on Google BigQuery through a Metabase integration using Rube MCP (Composio).

Automate InfluxDB Cloud operations like querying, managing buckets, and writing data through Composio's toolkit via Rube MCP.

Create and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries for database-like note management.

Organize, query, validate, and convert neuroscience and biomedical data using the Brain Imaging Data Structure (BIDS) standard.

Query 20+ bioinformatics databases from the command line or Python for gene information, sequences, protein structures, enrichment analysis, and more.

High-performance toolkit for genomic interval analysis in Rust with Python bindings. Use when working with genomic regions, BED files, coverage tracks, overlap detection, tokenization for ML models, or fragment analysis in computational genomics and machine learning applications.

Read, write, and manipulate genomic datasets including SAM/BAM/CRAM alignments, VCF/BCF variants, and FASTA/FASTQ sequences using a Pythonic interface to htslib.

Access AI-ready drug discovery datasets and benchmarks from Therapeutics Data Commons, covering ADME, toxicity, drug-target interactions, and molecular generation with standardized splits and evaluation metrics.