Skip to main content
Glama
CelpAI

celp-mcp

Official
by CelpAI

query-database

Converts natural language queries into multi-step SQL analysis plans and executes them against databases to answer complex analytical questions.

Instructions

Data Analyst Agent: Reasoning Analysis Mode

This tool translates natural language into multi-step SQL analysis plans and executes them against databases. Use this for complex analytical questions requiring more reasoning.

Capabilities

  • Performs multi-step analyses with each step building on previous results

  • Analyzes data across multiple tables with complex relationships

  • Handles complex queries requiring careful reasoning and planning

  • Produces comprehensive markdown reports with insights

When to Use

  • For complex analytical questions requiring deep reasoning

  • When accuracy and comprehensiveness is more important than speed

  • For queries involving multiple tables or complex relationships

  • When detailed insights and explanations are needed

Effective Prompts

  • Be specific about metrics, time periods, and entities of interest

  • Include relevant business context for interpretation

  • Specify desired output format (tables, charts, insights)

  • For complex analyses, break down into logical components

Restrictions:

  • Don't sent database credentials in the payload, it's handled by the server.

  • Don't sent API keys in the payload, it's handled by the server.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
promptYes
celpApiKeyNo
databaseConfigNo
databaseConnectionIdNo
Behavior3/5

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

With no annotations, the description carries full transparency burden. It discloses capabilities (multi-step analysis, cross-table reasoning, markdown reports) and restrictions (credentials handled server-side). However, it omits behavioral traits like whether it modifies data (assumed read-only but not stated), performance characteristics, or rate limits. Adequate but not comprehensive.

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

Conciseness3/5

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

The description is well-structured with sections (Capabilities, When to Use, Effective Prompts, Restrictions) and a clear title. However, it is lengthy and includes redundant guidance (e.g., 'Be specific about metrics'). Some sentences could be condensed. It is front-loaded but not optimally concise for an MCP tool description.

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

Completeness2/5

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

Given the tool's complexity (nested objects, no output schema, 4 parameters), the description is incomplete. It lacks parameter documentation, does not specify return format beyond 'markdown reports', and omits error handling or output schema details. The 'When to Use' is helpful but does not compensate for missing parameter semantics and output context.

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?

Schema description coverage is 0%. The description adds no information about parameters beyond the schema. It fails to explain what 'prompt', 'celpApiKey', 'databaseConfig', or 'databaseConnectionId' represent. The only hint is the restriction about credentials, which vaguely relates to 'celpApiKey' and 'databaseConfig.password'. This is insufficient for a tool with 4 parameters and complex nested objects.

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's purpose: 'translates natural language into multi-step SQL analysis plans and executes them against databases.' It explicitly labels itself as for 'complex analytical questions requiring more reasoning,' distinguishing it from sibling 'query-database-turbo' which implies a faster, simpler variant. The verb 'translates and executes' plus the resource 'databases' is specific. Good differentiation.

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 'When to Use' section provides clear context: complex questions, multi-table analyses, accuracy over speed, detailed insights. It also includes 'Restrictions' warning against sending credentials. However, it does not explicitly name sibling alternatives or state when NOT to use (e.g., simple queries should use query-database-turbo). The guidance is solid but lacks explicit exclusion criteria.

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

Install Server

Other Tools

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/CelpAI/celp-mcp'

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