Skip to main content
Glama

Supabase: Get database stats

supabase_get_database_stats
Read-only

Retrieve database statistics, including table count, total size, connection details, and PostgreSQL version, to assess health and capacity.

Instructions

[UNIFIED] Get database statistics including table count, total size, connection info, and PostgreSQL version.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "site": "<site>"
    },
    "name": "supabase_get_database_stats"
  }
}

Input Schema

NameRequiredDescriptionDefault
siteYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv3.14.0
  2. Removedv3.13.1
  3. First observedv3.4.0

TDQS

B3/5.0
Behavior3/5

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

The readOnlyHint annotation already establishes that this is a safe read operation, so the description's burden is lower. It adds the useful fact that several distinct data categories are returned in one call, but says nothing about cost, latency, or freshness of the statistics.

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

Conciseness4/5

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

One compact sentence with the verb and resource front-loaded and no filler. The "[UNIFIED]" prefix is mild noise that carries no evident meaning for tool selection.

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 simple read-only stats tool with no output schema, listing the returned categories is reasonably complete. The notable omission is any explanation of the required "site" argument, which is essential for calling the tool correctly.

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

Parameters2/5

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

The single required parameter "site" has 0% schema description coverage, and the description never mentions it at all. With one undocumented parameter, and arguably the most important one for invocation, the description does not compensate for the schema gap.

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?

A clear verb plus resource ("Get database statistics") followed by an enumeration of what those stats contain: table count, total size, connection info, and PostgreSQL version. That enumeration helps distinguish it from supabase_get_database_size, though the description never names a sibling explicitly.

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 supplies no when-to-use or when-not-to-use guidance. An agent must infer from the field list alone whether to reach for this tool or supabase_get_database_size / supabase_get_instance_info when it only wants size or version data.

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

Deploy Server

Other Tools