Schema | mcp-server-playground

mcp-server-playground

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MCP_HTTP_HOST`	No	Host for the Streamable HTTP server. Defaults to 127.0.0.1.	127.0.0.1
`MCP_HTTP_PORT`	No	Port for the Streamable HTTP server. Defaults to 4871 for plain HTTP and 4872 for the OAuth variant.	4871
`MCP_SQLITE_DB`	No	Override the database path. Defaults to data/shop.db resolved relative to the project root.	data/shop.db
`MCP_SQLITE_PERSIST`	No	Set to 1 to skip the database reset and reuse the existing database. Defaults to false (reset on each start).	0

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Functions exposed to the LLM to take actions

Name	Description
list_tablesA	List every table in the store database with its row count. Start here when exploring.
describe_tableA	Show the column definitions and three sample rows for one table.
search_productsB	Find products by keyword, category, price range or stock availability.
customer_ordersA	Look up a customer by id, email or partial name, and return their orders with line items already joined.
sales_summaryA	Aggregate sales over a date range, grouped by month, product category, brand, customer prefecture or order status. Cancelled orders are excluded unless grouping by status.
top_productsA	Rank products by revenue, units sold or average review rating over a date range.
search_reviewsA	Full-text search over review bodies. Returns matching reviews with the product they are about. Use this for questions about what customers say ("どの商品で破損の報告が多い?"), as opposed to search_products which only matches product names.
add_reviewB	Insert a new review row for a product. This modifies the database.

Interactive templates invoked by user choice

Name	Description
`monthly_report`	Draft a sales report for one month using the store data.
`product_deep_dive`	Investigate one product: sales trend, reviews, and who buys it.

Contextual data attached and managed by the client

Name	Description
`database-schema`	Full CREATE TABLE statements for every table in the store database.
`customers (sample rows)`	First 5 rows of a table, as JSON.
`order_items (sample rows)`	First 5 rows of a table, as JSON.
`orders (sample rows)`	First 5 rows of a table, as JSON.
`products (sample rows)`	First 5 rows of a table, as JSON.
`reviews (sample rows)`	First 5 rows of a table, as JSON.

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/etak64n/mcp-server-playground'

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