SQL & Databases

github Skill

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

github Skill

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

github Skill

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.

github Skill

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

github Skill

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

github Bundle

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.

github Skill

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

github Skill

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

github Skill

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

github Skill

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.

github Skill

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

github Skill

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.

github Skill

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

github Skill

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.

github Skill

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.

github Skill

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

github Skill

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

github Skill

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

bankrbot Bundle

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

bankrbot Bundle

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

composiohq Skill

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

kepano Bundle

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

k-dense-ai Bundle

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

k-dense-ai Bundle

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

k-dense-ai Bundle

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.

k-dense-ai Bundle

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

k-dense-ai Bundle

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.