Skip to main content
Glama
andrewwgordon

mcp-chinookdb-server

by andrewwgordon
OverviewSchemaSourceRelated ServersDiscussionsAdmin
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
run_sql_queryA
Executes a read-only (SELECT) SQL query against the Chinook database.
Only SELECT statements are allowed for safety.
Args:
    sql_query: The SQL SELECT query to execute.
Returns:
    Query results as a formatted string, or an error message.

Prompts

Interactive templates invoked by user choice

NameDescription
list_all_tables Generate a prompt to list all tables in the database using the schema resource. Returns a list of MCP prompt messages for LLMs.
show_table_schema Generate a prompt to show the schema for a specific table. Args: table_name: The name of the table to show the schema for. Returns: A string prompt for the LLM.
count_table_rows Generate a prompt to count the number of rows in a specific table. Args: table_name: The name of the table to count rows from. Returns: A string prompt for the LLM.
query_top_artists Generate a prompt to find the top N artists by the number of tracks they have. Args: limit: The number of top artists to retrieve (default is 5). Returns: A string prompt for the LLM.

Resources

Contextual data attached and managed by the client

NameDescription
list_tables_schema Provides the schema for all tables in the Chinook database. Returns a formatted string with the schema of each table.
Deploy Server
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

A3.8/5.0

Scored across 1 tool

Disambiguation5/5

Only one tool exists, so no ambiguity whatsoever.

Naming Consistency5/5

Single tool uses clear snake_case verb_noun pattern, perfectly consistent.

Tool Count3/5

One tool is on the low end; while it covers the core querying need, a few additional tools for schema discovery would improve utility.

Completeness3/5

Provides the essential SELECT query capability but lacks metadata tools (e.g., list tables, describe columns), which agents may need to form correct queries.

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources