query-optimization repositories

Trending repositories tagged query-optimization, ranked by trending score. Updated daily.

  1. 1
    feenlace/mcp-1c

    MCP server for 1С:Enterprise — AI assistant sees your configuration and generates accurate BSL code. One binary, zero dependencies, 19 tools.

    GitHub · Go · 257 stars · 49 forks · 0 stars in 24 hours · Trending score 0.77

  2. 2
    cristipufu/culprit-sql-studio

    Find what's slowing your database down: a free desktop app, CLI and MCP server for SQL Server, PostgreSQL, YugabyteDB, TimescaleDB, MySQL, MariaDB and SQLite performance (slow queries, execution plans, indexes, blocking, deadlocks).

    GitHub · Rust · 29 stars · 3 forks · +1 stars in 24 hours · Trending score 0.63

  3. 3
    alyiox/mcp-mssql

    Read-only-by-default MCP server for one or many SQL Servers: schema discovery, SELECT-only queries, execution-plan analysis, opt-in writes.

    GitHub · C# · 11 stars · 2 forks · +1 stars in 24 hours · Trending score 0.56

  4. 4
    GenLang-V/GenDB-V

    Towards AI-Generated and Formally Verified Database Systems

    GitHub · Rust · 23 stars · 1 forks · 0 stars in 24 hours · Trending score 0.27

  5. 5
    tableau/query-graphs

    A visualizer for queries - Hyper, Postgres, Tableau

    GitHub · TypeScript · 105 stars · 33 forks · 0 stars in 24 hours · Trending score 0.14

  6. 6
    ahmed-bhs/doctrine-doctor

    🩺⚡ Runtime Doctrine ORM analysis integrated into Symfony Web Profiler. Detect N+1 queries, security vulnerabilities, and performance issues during query execution.

    GitHub · PHP · 133 stars · 7 forks · 0 stars in 24 hours · Trending score 0.10

  7. 7
    cognica-io/uqa-engine

    Embeddable Rust query engine unifying relational, full-text, vector, graph, and probabilistic retrieval under one typed algebra.

    GitHub · Rust · 9 stars · 1 forks · 0 stars in 24 hours · Trending score 0.10

  8. 8
    Benziza/queryguard-dotnet

    Find repeated EF Core queries and catch query problems in tests. NuGet: https://www.nuget.org/packages/QueryGuard.Testing

    GitHub · C# · 11 stars · 0 forks · 0 stars in 24 hours · Trending score 0.09

  9. 9
    YawLabs/postgres-mcp

    Read-only-by-default MCP server for PostgreSQL. Query, introspect schemas, explain plans, health checks.

    GitHub · TypeScript · 10 stars · 2 forks · 0 stars in 24 hours · Trending score 0.08

  10. 10
    Releem/releem-agent

    Releem is a MySQL performance tuning tool with AI and controlled automation. Improve query performance and resource efficiency with workload-based recommendations.

    GitHub · Go · 308 stars · 29 forks · 0 stars in 24 hours · Trending score 0.01

  11. 11
    erikdarlingdata/PerformanceStudio

    Free, open-source SQL Server execution plan analyzer — cross-platform GUI + CLI with 30 analysis rules, missing index detection, SSMS extension. Built-in MCP server for AI-assisted plan review.

    GitHub · C# · 248 stars · 38 forks · 0 stars in 24 hours · Trending score 0.00

  12. 12
    SolidLao/GenDB

    GenDB, an LLM-Powered Generative Query Engine Built for the Future

    GitHub · C++ · 75 stars · 7 forks · 0 stars in 24 hours · Trending score 0.00

  13. 13
    theammarngp-makes/SQL-Engineering-Handbook

    SQL Engineeering Handbook by Mohammad Ammar . Production-ready with SQL tutorials, interview questions, real-world projects, query optimization, window functions, and analytics engineering examples. Created by the Co-Founder of Apex Analyticx . Live Portfolio : https://theammarngp.lovable.app

    GitHub · SQL · 13 stars · 4 forks · 0 stars in 24 hours · Trending score 0.00

  14. 14
    YimingQiao/bloom

    A DuckDB Extension: Adaptive robust predicate transfer for faster analytical joins in DuckDB.

    GitHub · C++ · 5 stars · 0 forks · 0 stars in 24 hours · Trending score 0.00

  15. 15
    wescaxeta/postgresql-queries

    Coleção de queries PostgreSQL | CTEs, window functions, índices, EXPLAIN ANALYZE e isolamento multi-tenant

    GitHub · PLpgSQL · 6 stars · 0 forks · 0 stars in 24 hours · Trending score 0.00

  16. 16
    agentscope-ai-java/duckdb-plan-lint

    Find DuckDB query plan anti-patterns — missing predicate pushdown, disk spills, cardinality misestimates.

    GitHub · Python · 15 stars · 0 forks · 0 stars in 24 hours · Trending score 0.00

  17. 17
    zio/zio-query

    Add efficient pipelining, batching, and caching to any data source

    GitHub · Scala · 153 stars · 22 forks · 0 stars in 24 hours · Trending score 0.00

  18. 18
    codegiveness/mssql-mcp

    MCP server (C#/.NET 11) for Microsoft SQL Server: list databases, inspect schemas, run read-only SQL with AST validation, query plans and health checks. npx, .NET tool or standalone binary; Restricted mode by default.

    GitHub · C# · 7 stars · 3 forks · Trending score 0.09