Skip to main content
Glama
ginkida

dbecho

by ginkida
OverviewSchemaRelated ServersScoreDiscussions
Python
Local

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_databasesA

List all configured PostgreSQL databases with their descriptions.

healthA

Check connectivity and basic info for all configured databases.

schemaA

Get the full schema of a database: tables, columns, types, primary keys, row counts, and sizes.

Args: database: Name of the database from config (use list_databases to see available).

queryA

Execute a read-only SQL query on a database and return results as a formatted table.

Only SELECT, WITH, EXPLAIN, and SHOW queries are allowed.

Args: database: Name of the database from config. sql: SQL query to execute (read-only).

analyzeB

Profile a table: row count, column types, null percentages, distinct values, min/max/avg for numeric columns, top values for low-cardinality text columns.

Args: database: Name of the database from config. table: Name of the table to analyze.

compareA

Run the same SQL query across multiple databases and compare results side by side.

Args: sql: SQL query to execute on each database (must be SELECT). databases: List of database names to compare. If omitted, runs on all databases.

summaryA

Get a quick overview of all databases: table counts, total rows, largest tables, database sizes.

trendA

Analyze time series data: group rows by time period and show counts, averages, and totals.

Args: database: Name of the database from config. table: Name of the table. date_column: Name of the date/timestamp column to group by. value_column: Optional numeric column to aggregate (avg, sum). If omitted, shows counts only. period: Grouping period: day, week, month, quarter, year. Default: month.

anomaliesA

Find data quality issues in a table: high null rates, single-value columns, numeric outliers, future dates, possible duplicates.

Args: database: Name of the database from config. table: Name of the table to check.

sampleA

Show sample rows from a table to understand the data format.

Args: database: Name of the database from config. table: Name of the table. limit: Number of rows to return (default 5, max 50).

erdB

Show entity-relationship diagram as text: tables, primary keys, and foreign key relationships.

Args: database: Name of the database from config.

Prompts

Interactive templates invoked by user choice

NameDescription
explore_databaseGuided exploration of a database: schema, summary, sample data from key tables.
compare_databasesCompare all databases: find common tables, compare row counts and structures.
data_quality_reportRun a comprehensive data quality check on all tables in a database.

Resources

Contextual data attached and managed by the client

NameDescription
resource_databasesList of all configured databases.

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/ginkida/dbecho'

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