Skip to main content
Glama
elekto-com-br

Elekto MCP for SQL Server

Official

List views

list_views
Read-onlyIdempotent

Lists database views with their schema so you can find views by name or schema. Filter large databases by schema or name pattern.

Instructions

Lists user views with their schema. Use it to find views by name or schema; for a view's columns and SQL text use get_view_definition, and for tables use list_tables. Narrow large databases with schema and name_pattern.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
schemaNoFilter by schema name. Empty means every schema. Example: 'Feeder'
databaseYesName of the database as registered in the configuration.
name_patternNoFilter by view name. A pattern without % matches anywhere in the name; add % yourself for a prefix or suffix match. Empty means every view.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.2/5.0
Behavior3/5

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

Annotations already declare readOnlyHint, idempotentHint, openWorldHint=false, and destructiveHint=false, so the safety profile is fully covered elsewhere. The description adds the operational hint that schema and name_pattern narrow large databases, plus a hint that the result includes each view's schema, but says nothing about pagination or the full return shape. Useful context on top of annotations, but not rich.

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 tight sentences with zero filler: the purpose and output scope come first, then the alternatives, then the filtering advice. Every clause 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?

For a simple three-parameter read-only list tool with annotations covering safety and a fully documented schema, the description supplies purpose, alternatives, and narrowing guidance. The only omission is any mention of result limits or pagination, which is minor here.

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%, so the schema already documents all three parameters including pattern semantics and defaults, making 3 the baseline. The description reinforces how schema/name_pattern are used for narrowing large databases but adds no syntax or meaning beyond what the schema states.

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?

States a specific verb and resource ('Lists user views with their schema') and explicitly distinguishes itself from the sibling tools that return view details (get_view_definition) and tables (list_tables). An agent can route correctly without opening any 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 gives the when ('find views by name or schema') and names two alternatives with the condition that selects each: get_view_definition for columns/SQL text, list_tables for tables. Nothing is left to inference.

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