Schema | pubdata-mcp

pubdata-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`PUBDATA_DATA_GO_KR_KEY`	No	Service key for data.go.kr API to fetch real data instead of mock data. Optional.

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
list_datasetsA	List datasets available in the mart with their title and description.
describe_schemaB	Return column names and types for a table so the agent can write SQL.
query_sqlA	Run a read-only SELECT against the mart. Only single SELECT / WITH statements are allowed; results are row-capped. Use describe_schema to learn column names before querying.
price_statsA	Average / min / max / count of price_manwon grouped by a column. A convenience analytics tool so the agent needn't hand-write aggregation SQL.
correlateA	Pearson correlation between two numeric columns across two datasets. Joins the tables on their shared keys (obs_date and/or region_code) and returns corr(col_a, col_b) plus the joined sample size. Example: correlate weather.avg_wind_ms with air_quality.pm10 to see whether windy days have cleaner air. Table and column names are validated against the live schema before use.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
`catalog`	Human-readable catalog of datasets, exposed as an MCP resource.

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/jcyeom/pubdata-insight-mcp'

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