Skip to main content
Glama
Michael2150

flamerobin-mcp-server

get_view_source

Retrieves the SQL SELECT statement that defines a view in a Firebird database. Provide the database key and view name to get the view source or an error if not found.

Instructions

Return the source SQL of a view. database: key from list_databases. view: view name from list_objects (type='views') — automatically uppercased. Returns the SELECT statement that defines the view, or an error message if not found.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
databaseYes
viewYes
Behavior3/5

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

Discloses key behaviors: returns SELECT statement or error message, automatically uppercases view name. No annotations provided, so description carries full burden. Could mention read-only nature or permission requirements, but the given info 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?

Two sentences: first for purpose, second for parameter details and behavior. No filler, front-loaded, every sentence adds value.

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?

Covers all essential aspects for a simple retrieval tool: parameter sourcing, automatic transformation, and output format. No output schema needed as return type is implied. Minor gap: no mention of error format or pagination (not relevant here).

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

Parameters5/5

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

Adds significant meaning beyond the bare schema: explains database comes from list_databases, view from list_objects with type='views', and that view is automatically uppercased. With 0% schema coverage, this is essential and well-done.

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 verb 'Return' and the resource 'source SQL of a view'. It distinguishes from sibling tools like get_procedure_source by specifying 'view' and referencing specific sources (list_databases, list_objects with type='views').

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?

Provides explicit guidance on where to obtain parameter values (list_databases for database, list_objects for view) and notes automatic uppercasing. However, it lacks explicit when-to-use vs alternatives, e.g., 'Use this for views; for procedures use get_procedure_source'.

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/Michael2150/flamerobin-mcp-server'

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