Skip to main content
Glama

db_tables

List all database tables with row counts to analyze structure and data volume across SQLite, PostgreSQL, and MySQL databases.

Instructions

List all tables in the database with row counts.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
typeYesDatabase type
connectionNoConnection string
hostNoDatabase host
portNoPort number
databaseNoDatabase name
userNoUsername
passwordNoPassword
Behavior2/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. While 'List' implies a read-only operation, it doesn't specify whether this requires authentication, what happens if the connection fails, whether results are paginated, or what format the output takes. For a tool with 7 parameters and no annotation coverage, this is insufficient.

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 a single, efficient sentence that immediately conveys the core functionality. There's no wasted words or unnecessary elaboration - every word earns its place in defining what the tool does.

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?

For a read-only listing tool with comprehensive schema documentation (100% coverage), the description provides adequate basic purpose. However, with no output schema and no annotations, it should ideally mention something about the return format or structure. The description is complete enough for basic understanding but lacks depth for a tool with multiple connection parameters.

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?

The schema description coverage is 100%, so all parameters are documented in the schema itself. The description doesn't add any parameter-specific information beyond what's already in the schema (e.g., it doesn't explain how parameters interact or which combinations are valid). This meets the baseline for high schema coverage.

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 specific action ('List all tables') and resource ('in the database') with additional detail about what information is included ('with row counts'). It distinguishes itself from sibling tools like db_query (which executes queries) and db_schema (which might show schema details without counts).

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

Usage Guidelines2/5

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

The description provides no guidance on when to use this tool versus alternatives like db_schema or db_query. It doesn't mention prerequisites (e.g., needing a database connection established first) or compare it to other database-related tools in the sibling list.

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/ShunsukeHayashi/miyabi-mcp-bundle'

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