Results for “query-plan”
20 skills
seb1n Query Optimization
Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. Use when the user provides a query, performance symptom, or EXPLAIN plan; use sql-query-generation when creating a new query from requirements.
159
eli-yu-first SQL Query Optimizer
Optimizes SQL queries with execution plan analysis, index suggestions, and query rewriting
6 · bundle
github Qdrant Scaling
Guides scaling decisions for Qdrant vector databases based on data volume, query throughput, latency, or query volume.
36.2k
seb1n SQL Query Generation
Generate SQL queries from natural-language requirements using SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries. Use when the user needs a new query from a business question or schema; use query-optimization when an existing query or execution plan is slow.
159
agentskillexchange Postgres MCP Pro
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.
28
jeffallan SQL Pro
Optimizes SQL queries, designs database schemas, and troubleshoots performance issues using execution plan analysis, indexing strategies, and set-based operations.
10.4k · bundle
More results
jeffallan Database Optimizer
Optimizes database queries and improves performance across PostgreSQL and MySQL systems by analyzing execution plans, designing index strategies, and tuning configurations.
10.4k · bundle
github Qdrant Search Quality
Diagnoses and improves Qdrant search relevance by isolating embedding model, configuration, or query strategy issues.
36.2k
rulebase-co Rulebase Workspace SQL
Use when querying a Rulebase workspace with SQL through the MCP server's query tool — writing queries that finish inside the statement timeout, and avoiding the join fan-outs that silently inflate QA evaluation counts. Trigger for "query my Rulebase data", "the query timed out", "statement timeout", "canceling statement due to statement timeout", counts that don't reconcile between two Rulebase queries, criterion counts exceeding team counts, or any multi-step analysis over Rulebase conversations and evaluations.
1
github Qdrant Performance Optimization
Optimize Qdrant vector search performance through indexing strategies, query tuning, memory management, and hardware considerations.
36.2k
google Bigtable Basics
Provision Bigtable instances, design performant schemas, and query data using gcloud, cbt, or client libraries.
14.4k · bundle
tools-only 103 SQL 05f5e3f4
Guides database index selection, creation, and maintenance with SQL examples for PostgreSQL and MySQL.
7 · bundle
tools-only 160 SQL Dce3acf3
Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.
7 · bundle
saranskumar SQL Optimization
Use when debugging slow SQL queries, designing database indexes, or rewriting queries for better performance. For EXPLAIN analysis, index strategy, N+1 problem resolution, and query optimization patterns.
0
snoodleboot-io SQL Optimization
Always start with EXPLAIN ANALYZE to understand execution:
2
timlai666 SQL Pro
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
1 · bundle
mariadb-corporation Mariadb Explain
Explains MariaDB-specific EXPLAIN and ANALYZE syntax, including FORMAT=JSON, SHOW EXPLAIN/ANALYZE FOR, and the standalone ANALYZE statement that executes queries.
0
jarbitechture SQL Pro
Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle).
0 · bundle
github SQL Optimization
Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.
36.2k
schattenspiegel Duckdb Python
Use for writing, reviewing, debugging, testing, or optimizing Python code that embeds DuckDB, executes analytical SQL, manages DuckDB connections and transactions, builds DuckDB relations, queries Parquet/CSV/Arrow/pandas/Polars inputs, or exports query results. Trigger on connection scope, parameters, replacement scans, materialization, concurrency, extensions, and query plans. Do not use for generic SQL with another engine, DuckDB CLI-only work, server-database administration, dbt-only projects, or dataframe work that does not call DuckDB.
0 · bundle