Skip to main content
Glama
xFoundry

BaseQL MCP Server

by xFoundry

queryTable

Query data from tables with filtering, sorting, and pagination. Supports advanced filter operators for precise record retrieval.

Instructions

Query data from a table with filtering, sorting, and pagination. Use this for most data retrieval needs. filter is passed directly to BaseQL _filter (supports operators like _eq, _in, _and, _or). Exact matches are case-sensitive unless you use advanced operators in _filter.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sortNoSort options, e.g., [{"field": "lastName", "direction": "asc"}]
limitNoMaximum records to return (default: 10, max: 100)
fieldsNoSpecific fields to return, e.g., ["id", "firstName", "email"]. Omit to get all fields (slower).
filterNoBaseQL _filter object. Exact matches are case-sensitive, e.g., {"type": {"_eq": "Student"}}. Supports _and/_or and _eq/_ne/_in/_nin/_gt/_gte/_lt/_lte. For linked records, filter by ID: {"purchaser": ["rec123xyz"]}.
offsetNoRecords to skip for pagination. Example: offset 20 with limit 10 gets records 21-30.
tableNameYesTable name to query (use listTables to see options)
Behavior3/5

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

With no annotations provided, the description carries the full disclosure burden. It adds useful context about filter passthrough to BaseQL and the case-sensitivity nuance ("Exact matches are case-sensitive unless you use advanced operators in _filter"). However, it does not disclose the response format or whether pagination metadata is returned, and the read-only safety profile is only implied by the verb "Query".

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 three efficient sentences: purpose, usage positioning, and filter/case-sensitivity caveat. It is front-loaded with the core operation and every sentence earns its place with no redundancy.

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

Completeness3/5

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

The input schema richly covers all parameters, but with no output schema, the description should clarify what the tool returns (records shape, pagination metadata, total counts). It does not. Additionally, the sibling "query" is ambiguous and the description never clarifies when one would use "query" instead of "queryTable".

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 100% and each of the 6 parameters has a detailed description. The description adds only marginal value for filter (passthrough note and the "unless advanced operators" caveat) while the schema already documents operators, examples, and case-sensitivity more thoroughly. No new meaning is added for tableName, sort, limit, offset, or fields.

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

Purpose4/5

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

The description clearly states a specific verb+resource+scope: "Query data from a table with filtering, sorting, and pagination." The phrase "Use this for most data retrieval needs" positions it against siblings, but it does not explicitly differentiate from the similarly named sibling "query", leaving some ambiguity.

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?

"Use this for most data retrieval needs" gives clear context that this is the go-to retrieval tool. It does not name exclusions or explicitly direct agents to alternatives like searchTable or getFieldOptions for specialized cases, but the guidance is reasonably clear.

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/xFoundry/baseql-mcp'

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