Skip to main content
Glama
Nitesh-Nandan

query-executor

Server Quality Checklist

58%
Profile completionA complete profile improves this server's visibility in search results.
  • Latest release: v0.1.0

  • Disambiguation5/5

    Each tool has a clearly distinct purpose: schema inspection, query execution, explain planning, project listing, and performance analysis. No overlap exists.

    Naming Consistency4/5

    Tools follow a mostly consistent verb_noun pattern (describe_, execute_, explain_, list_), except pg_stat_statements which is a fixed PostgreSQL function name. Overall, naming is clear and predictable.

    Tool Count5/5

    Five tools is ideal for a query executor, covering key operations without unnecessary overhead. Each tool serves a specific need.

    Completeness5/5

    The tool set covers essential operations: schema inspection, query execution with read-only/write modes, explain analysis, project management, and performance monitoring. No obvious gaps for the domain.

  • Average 4.4/5 across 5 of 5 tools scored. Lowest: 3.8/5.

    See the Tool Scores section below for per-tool breakdowns.

    • No community issues in the last 6 months
    • 0 commits in the last 12 weeks
    • No stable releases found
    • No critical vulnerability alerts
    • No high-severity vulnerability alerts
    • No code scanning findings
    • CI status not available
  • Add a LICENSE file by following GitHub's guide. Once GitHub recognizes the license, the system will automatically detect it within a few hours.

    If the license does not appear after some time, you can manually trigger a new scan using the MCP server admin interface.

    MCP servers without a LICENSE cannot be installed.

  • This repository includes a README.md file.

  • No tool usage detected in the last 30 days. Usage tracking helps demonstrate server value.

    Tip: use the "Try in Browser" feature on the server page to seed initial usage.

  • Add a glama.json file to provide metadata about your server.

  • If you are the author, simply .

    If the server belongs to an organization, first add glama.json to the root of your repository:

    {
      "$schema": "https://glama.ai/mcp/schemas/server.json",
      "maintainers": [
        "your-github-username"
      ]
    }

    Then . Browse examples.

  • Add related servers to improve discoverability.

How to sync the server with GitHub?

Servers are automatically synced at least once per day, but you can also sync manually at any time to instantly update the server profile.

To manually sync the server, click the "Sync Server" button in the MCP server admin interface.

How is the quality score calculated?

The overall quality score combines two components: Tool Definition Quality (70%) and Server Coherence (30%).

Tool Definition Quality measures how well each tool describes itself to AI agents. Every tool is scored 1–5 across six dimensions: Purpose Clarity (25%), Usage Guidelines (20%), Behavioral Transparency (20%), Parameter Semantics (15%), Conciseness & Structure (10%), and Contextual Completeness (10%). The server-level definition quality score is calculated as 60% mean TDQS + 40% minimum TDQS, so a single poorly described tool pulls the score down.

Server Coherence evaluates how well the tools work together as a set, scoring four dimensions equally: Disambiguation (can agents tell tools apart?), Naming Consistency, Tool Count Appropriateness, and Completeness (are there gaps in the tool surface?).

Tiers are derived from the overall score: A (≥3.5), B (≥3.0), C (≥2.0), D (≥1.0), F (<1.0). B and above is considered passing.

Tool Scores

  • Behavior4/5

    Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

    With no annotations provided, the description carries the full burden of behavioral disclosure. It explains that query text uses $1/$2 placeholders (normalization), notes the extension requirement with deployment-specific details, and outlines the return format. It is transparent about the read-only nature and typical usage, but does not explicitly declare non-destructiveness.

    Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

    Conciseness4/5

    Is the description appropriately sized, front-loaded, and free of redundancy?

    The description is concise (about 4 sentences), front-loaded with the purpose, and well-structured with a clear breakdown of return format, normalization behavior, and extension requirements. A minor quibble is the inline return schema which adds some verbosity, but overall it earns its place.

    Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

    Completeness4/5

    Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

    Given the complexity of a database performance tool and the presence of an output schema (not shown but referenced), the description covers purpose, return format, normalization, and extension prerequisites. It lacks parameter explanation but the input schema covers that. Overall it is complete enough for an agent to understand the tool's role.

    Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

    Parameters1/5

    Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

    The description does not explain the parameters (limit and project_id) at all. Given the schema description coverage is 0%, the description should compensate, but it fails to add any meaning beyond the schema's own parameter descriptions. The agent must infer the limit from 'top N' and is left uninformed about project_id.

    Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

    Purpose5/5

    Does the description clearly state what the tool does and how it differs from similar tools?

    The description clearly states 'Return the top N most expensive queries from pg_stat_statements,' specifying a specific verb and resource. It further positions this as the 'best starting point for a performance audit,' which distinguishes it from sibling tools like execute_postgres or explain_postgres.

    Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

    Usage Guidelines4/5

    Does the description explain when to use this tool, when not to, or what alternatives exist?

    The description provides clear context for use ('Best starting point for a performance audit') and implies it is for identifying costly query patterns. It does not explicitly state when not to use it or name alternatives, but the context and sibling tool names make the intended usage clear.

    Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

  • Behavior3/5

    Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

    With no annotations, the description carries the full burden. It describes the return structure and warns about large schemas, but does not explicitly state read-only nature, required permissions, or error handling. The word 'Inspect' implies read-only, but more explicit disclosure would improve transparency.

    Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

    Conciseness4/5

    Is the description appropriately sized, front-loaded, and free of redundancy?

    The description is concise (about 100 words) and front-loaded with purpose. It uses bullet-style formatting for the return structure. There is no unnecessary verbosity, but it could be slightly tighter by condensing the usage advice.

    Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

    Completeness4/5

    Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

    Given the tool's simplicity and the presence of an output schema, the description covers key aspects: purpose, when to use, return format, and large schema handling. Minor gaps include not specifying behavior for nonexistent schemas or error conditions.

    Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

    Parameters3/5

    Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

    Schema description coverage is high (both parameters have descriptions in the schema), so baseline is 3. The tool description does not mention parameters or provide additional semantics beyond what the schema already offers.

    Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

    Purpose5/5

    Does the description clearly state what the tool does and how it differs from similar tools?

    The description clearly states 'Inspect a PostgreSQL schema and return its full structure as JSON'. It differentiates from sibling tools like execute_postgres (execution), explain_postgres (query plan), list_projects (project listing), and pg_stat_statements (statistics), all of which have distinct purposes.

    Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

    Usage Guidelines4/5

    Does the description explain when to use this tool, when not to, or what alternatives exist?

    Explicitly advises 'Call this before writing any query, JOIN, or EXPLAIN — it gives you exact table/column names and indexes so you don't guess'. It also recommends filtering client-side for large schemas, though it doesn't explicitly state when not to use or list alternatives.

    Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

  • Behavior4/5

    Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

    No annotations are provided, so the description carries the burden. It discloses the return type (JSON object) and data source (databases.json), listing fields like 'default_project' and 'projects'. It does not mention authorization or side effects, but for a read-only listing tool, this level of transparency is adequate.

    Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

    Conciseness5/5

    Is the description appropriately sized, front-loaded, and free of redundancy?

    The description is concise, with three short segments: purpose, usage advice, and return format. It front-loads the key action and resource, and every sentence adds value without redundancy.

    Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

    Completeness5/5

    Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

    Given zero parameters and an output schema described inline, the description is complete. It fully explains the tool's behavior, when to call it, and the structure of results, leaving no ambiguity for an AI agent.

    Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

    Parameters4/5

    Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

    The tool has no parameters, and schema description coverage is 100% (empty schema). The description adds context about the returned structure, which enhances understanding beyond the schema, earning a baseline score of 4.

    Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

    Purpose5/5

    Does the description clearly state what the tool does and how it differs from similar tools?

    The description clearly states the tool lists all configured database projects and their access modes, using specific verb 'list' and resource 'database projects'. It distinguishes itself from sibling tools like 'execute_postgres' or 'describe_postgres_schema' which target different operations.

    Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

    Usage Guidelines4/5

    Does the description explain when to use this tool, when not to, or what alternatives exist?

    The description explicitly advises 'Call this first when you don't know which project_id to use', providing a clear usage scenario. However, it does not mention when not to use it or suggest alternatives, but given the context, this guidance is sufficient.

    Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

  • Behavior5/5

    Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

    With no annotations, the description fully discloses key behaviors: mode enforcement (readonly blocks writes), return format with row_count, type casting for non-serialisable types, and the indicator that row_count equal to LIMIT suggests more rows. No contradictions.

    Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

    Conciseness5/5

    Is the description appropriately sized, front-loaded, and free of redundancy?

    Concise and well-structured: purpose, return format, mode behavior, prerequisite call, and a caution about LIMIT. Every sentence adds value and the most critical info is front-loaded.

    Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

    Completeness5/5

    Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

    Covers prerequisites, mode details, common pitfalls (LIMIT), and return format. With an output schema present (context signal), description does not need to explain return values further. No gaps identified.

    Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

    Parameters4/5

    Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

    Input schema already provides parameter descriptions (sql and project_id). The description adds context about mode behavior affecting the sql parameter and suggests LIMIT usage, but does not elaborate on parameter syntax or format beyond the schema. Given low schema description coverage (0%), it compensates partially but not fully.

    Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

    Purpose5/5

    Does the description clearly state what the tool does and how it differs from similar tools?

    Clearly states the tool executes SQL queries on a PostgreSQL database and returns rows as JSON. Distinguishes from siblings like 'describe_postgres_schema' and 'explain_postgres' by focusing on execution rather than schema inspection or query planning.

    Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

    Usage Guidelines5/5

    Does the description explain when to use this tool, when not to, or what alternatives exist?

    Includes explicit guidance: call 'describe_postgres_schema' first, explains mode behavior (readonly vs readwrite) with conditions, and advises adding LIMIT for unfamiliar tables. Effectively helps agents decide when and how to use this tool vs alternatives.

    Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

  • Behavior5/5

    Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

    Discloses that the query executes to collect real timing, results are discarded, a statement timeout prevents runaway, and write queries are blocked. With no annotations, the description fully covers behavioral traits.

    Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

    Conciseness5/5

    Is the description appropriately sized, front-loaded, and free of redundancy?

    The description is concise, front-loaded with the main action, followed by execution details, return format, and usage guidance. Every sentence adds value with no wasted words.

    Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

    Completeness5/5

    Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

    The description covers what the tool does, how it works (including execution and timeout), return format, when to use, and what is blocked. With an output schema present (not shown but referenced), the return information is sufficient. All necessary context for an agent to use the tool correctly is provided.

    Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

    Parameters4/5

    Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

    The input schema already provides detailed parameter descriptions. The tool description adds context like the automatic prepending of EXPLAIN and the 'write queries blocked' constraint, but does not repeat parameter definitions. Given schema coverage appears to be limited (per context signals), the description could have added more direct parameter guidance, but it is adequate.

    Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

    Purpose5/5

    Does the description clearly state what the tool does and how it differs from similar tools?

    Clearly states it runs EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) on a query and returns the plan. Distinguishes from sibling tools like execute_postgres (which runs queries) and describe_postgres_schema (which describes schema).

    Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

    Usage Guidelines5/5

    Does the description explain when to use this tool, when not to, or what alternatives exist?

    Explicitly advises using this tool before slow/unfamiliar queries on large tables, and to check describe_postgres_schema first for indexes. Also states write queries are blocked, guiding the agent away from using it for writes.

    Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

GitHub Badge

Glama performs regular codebase and documentation scans to:

  • Confirm that the MCP server is working as expected.
  • Confirm that there are no obvious security issues.
  • Evaluate tool definition quality.

Our badge communicates server capabilities, safety, and installation instructions.

Card Badge

query-executor MCP server

Copy to your README.md:

Score Badge

query-executor MCP server

Copy to your README.md:

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Nitesh-Nandan/query-executor'

If you have feedback or need assistance with the MCP directory API, please join our Discord server