Search for:

Techniques for Optimizing Oracle Database Queries

  • Why this server?

    A template project for building custom MCP servers that enables direct access to PostgreSQL databases, allowing SQL query execution and schema information retrieval through the Model Context Protocol, useful as a base to build an oracle query optimizer.

    -
    security
    A
    license
    -
    quality
    A template project for building custom MCP servers that enables direct access to PostgreSQL databases, allowing SQL query execution and schema information retrieval through the Model Context Protocol.
    Last updated -
    3
    Python
    MIT License
    • Apple
    • Linux
  • Why this server?

    Enables interaction with a MySQL database via JSON commands, supporting read-only queries, test execution of write queries, and table information retrieval through Docker, helpful for optimizing queries

    A
    security
    A
    license
    A
    quality
    Enables interaction with a MySQL database via JSON commands, supporting read-only queries, test execution of write queries, and table information retrieval through Docker.
    Last updated -
    4
    5
    5
    JavaScript
    MIT License
  • Why this server?

    A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries; helpful for understanding existing queries before optimization.

    -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
    Last updated -
    1,219
    133
    TypeScript
    MIT License
    • Linux
    • Apple
  • Why this server?

    Provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries, which is beneficial for query optimization.

    -
    security
    -
    license
    -
    quality
    A Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
    Last updated -
    1
    JavaScript
  • Why this server?

    Convex’s MCP server lets you introspect tables, call functions, and read/write data seamlessly. Agents can generate one-off queries safely—thanks to Convex’s sandboxed queries, ensuring data integrity, which is useful for analyzing query performance and safety

    -
    security
    F
    license
    -
    quality
    Convex’s MCP server lets you introspect tables, call functions, and read/write data seamlessly. Agents can generate one-off queries safely—thanks to Convex’s sandboxed queries, ensuring data integrity. Perfect for AI automation, real-time apps, and dynamic data access.
    Last updated -
    3,955
    Rust
    • Linux
    • Apple
  • Why this server?

    Provides generic Open Database Connectivity (ODBC) to any Database Management System (DBMS) that's accessible via an ODBC Connector (Driver), meaning it could connect to Oracle and thus is useful to optimize queries.

    -
    security
    A
    license
    -
    quality
    Provides generic Open Database Connectivity (ODBC) to any Database Management System (DBMS) that's accessible via an ODBC Connector (Driver).
    Last updated -
    TypeScript
    MIT License
    • Apple
  • Why this server?

    Provides SQLAlchemy (via pyodbc) connectivity to any Database Management System (DBMS) that's accessible via SQLAlchemy, allowing for read and write operations which is useful for testing optimized queries against an Oracle database.

    A
    security
    A
    license
    A
    quality
    Provides SQLAlchemy (via pyodbc) connectivity to any Database Management System (DBMS) that's accessible via SQLAlchemy.
    Last updated -
    11
    7
    Python
    Apache 2.0
    • Apple
    • Linux
  • Why this server?

    DBCode is a Visual Studio Code extension that allows you to manage many databases... DBCode offers the option to run an MCP server, providing access to those databases, their schemas, and the ability to execute queries.

    -
    security
    F
    license
    -
    quality
    DBCode is a Visual Studio Code extension that allows you to manage many databases, including PostgreSQL, MySQL, SQL Server, DuckDB, Redis, MongoDB, and more. DBCode offers the option to run an MCP server, providing access to those databases, their schemas, and the ability to execute queries.
    Last updated -
    3
    91
    • Linux
    • Apple
  • Why this server?

    A Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools, for PostgreSQL but can be adapted for oracle

    -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools.
    Last updated -
    TypeScript