Sofia Data MCP server
Commit Nov 10, 2026Allows AI clients to access and query urban datasets from the Sofia municipality portal via CKAN integration.
Also known as manevpe/sofia-data-mcp
- Stars
- 0
- Tools
- 11
- Downloads, 30 days
- —
- Latest version
- —
- Last commit
- Nov 10, 2026
- License
- MIT
What is Sofia Data MCP?
Sofia Data allows AI clients to access and query urban datasets from the Sofia municipality portal via CKAN integration. It exposes 11 tools, such as search_datasets, get_dataset, list_groups.
Summary generated from the project's README
About Sofia Data MCP server
Querying urban datasets from the Sofia municipality portal is what this server enables for developers and data analysts. By integrating directly with the CKAN Action API, it provides an interface for AI clients to explore municipal information through tools like search_datasets, list_groups, and get_dataset. The system is designed to handle complex metadata, including automatic repair of corrupted Cyrillic group names and semantic profiling based on tags and formats.
Users can connect via a public HTTP endpoint for native support in Cursor or VS Code Copilot Chat. For clients restricted to local processes like Claude Desktop, the server offers a stdio bridge that forwards requests to the remote URL. It requires Node.js 24+ and can be run locally via pnpm or deployed to Google Cloud Run. The server includes an in-memory cache for CKAN reads to improve performance and manages data through specific tools like facet_datasets and preview_resource to inspect JSON or GeoJSON content.
What you can do with it
- 1Search municipal datasetsAn AI agent can find specific urban data files by searching the municipality's catalog.
- 2Analyze data distributionUsers can request counts of datasets categorized by license, format, or organization.
Written from the project's README. Every use case is checked against a quote from it.
Sofia Data MCP tools 11
Detected from the READMEsearch_datasetsget_datasetlist_groupsget_grouplist_organizationsget_organizationlist_dataset_resourcespreview_resourcesummarize_datasetfind_related_datasetsfacet_datasets
| search_datasets | — | |
| get_dataset | — | |
| list_groups | — | |
| get_group | — | |
| list_organizations | — | |
| get_organization | — | |
| list_dataset_resources | — | |
| preview_resource | — | |
| summarize_dataset | — | |
| find_related_datasets | — | |
| facet_datasets | — |
Configuration
E2E_BASE_URL
| Name | Description | |
|---|---|---|
| E2E_BASE_URL | — |
Automated checks
Ran Nov 14, 2026Full report →Not verified yet. A server needs a score of 80, no serious finding, and enough data for us to check. How checks work · What to fix for more points
- Source repository linked and reachablemanevpe/sofia-data-mcp is public and reachablegithub.com/manevpe/sofia-data-mcp ↗Pass
- Package names this repository as its sourceNot checked
- Build provenance (Sigstore attestation)Not checked
- Open source license (OSI)MITspdx.org/licenses/MIT.html ↗Pass
- Commit or release in the last yearLast commit or release 2026-11-10github.com/manevpe/sofia-data-mcp ↗Pass
- OpenSSF ScorecardNot checked
- Package name not close to a popular packageNot checked
- No critical advisory in the package or its dependenciesNot checked
- No hidden instructions to the model11 tool descriptions and the README read; no override phrases, credential paths or hidden charactersPass
- Destructive tools are labelledNo tool named like delete, drop or execPass
- Remote endpoint answers the MCP handshakeNot checked
README
View on GitHubSofia Data MCP
TypeScript MCP server, stdio bridge, and CLI client for the Sofia municipality urban data portal at https://urbandata.sofia.bg.
Architecture
- Canonical server transport: Streamable HTTP
- Desktop compatibility transport: local
stdiobridge that forwards to HTTP - Local default endpoint:
http://127.0.0.1:3000/mcp - Source portal integration: CKAN Action API
Connect an MCP Client
The deployed server is public, requires no auth, and speaks Streamable HTTP at:
https://sofia-data-mcp-oparjiwnqa-ew.a.run.app/mcp
Clients with native remote/HTTP MCP support (recommended)
VS Code (Copilot Chat) — add to .vscode/mcp.json in your project (or
your user mcp.json via the MCP: Open User Configuration command):
{
"servers": {
"sofia-data": {
"type": "http",
"url": "https://sofia-data-mcp-oparjiwnqa-ew.a.run.app/mcp"
}
}
}
Cursor — add to .cursor/mcp.json:
{
"mcpServers": {
"sofia-data": {
"url": "https://sofia-data-mcp-oparjiwnqa-ew.a.run.app/mcp"
}
}
}
Clients that only support local stdio servers (e.g. Claude Desktop)
Claude Desktop's claude_desktop_config.json only launches local processes,
so bridge to the remote HTTP endpoint with the widely-used mcp-remote
adapter (no install/build required, runs via npx):
{
"mcpServers": {
"sofia-data": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://sofia-data-mcp-oparjiwnqa-ew.a.run.app/mcp"
]
}
}
}
Alternatively, this repo's own @sofia-data/stdio-bridge package works the
same way — point it at the deployed URL instead of running the server
locally:
pnpm --filter @sofia-data/stdio-bridge dev -- \
--upstream-url https://sofia-data-mcp-oparjiwnqa-ew.a.run.app/mcp
Quick smoke test (no client needed)
curl -s https://sofia-data-mcp-oparjiwnqa-ew.a.run.app/health
Packages
@sofia-data/core: shared CKAN client, normalization, analytics, and MCP tool definitions@sofia-data/http-server: HTTP MCP server@sofia-data/stdio-bridge:stdiobridge to an HTTP MCP server@sofia-data/cli: bilingual CLI client
Requirements
- Node.js 24+
- Corepack available
Install
corepack enable
corepack prepare pnpm@10.8.1 --activate
pnpm install
Build
pnpm build
Run Locally
Start the HTTP server:
pnpm dev:server
Default endpoint:
http://127.0.0.1:3000/mcp
Run the CLI:
pnpm dev:cli
Run the stdio bridge:
pnpm dev:bridge
Override the bridge upstream URL:
pnpm --filter @sofia-data/stdio-bridge dev -- --upstream-url http://127.0.0.1:3000/mcp
Docker
Build and run with Docker Compose:
docker compose up --build
End-to-End Tests
packages/e2e runs a full black-box smoke test against a deployed
instance (health check, MCP initialize handshake, listTools, and a real
search_datasets call) — distinct from packages/http-server's unit tests,
which spin up a local in-process server. It's skipped automatically (not
failed) when no target is given, so it never affects normal pnpm test/CI:
E2E_BASE_URL=https://sofia-data-mcp-oparjiwnqa-ew.a.run.app pnpm test:e2e
This also runs automatically as a post-deploy gate in
.github/workflows/deploy.yml, against the URL of the revision that was
just deployed.
Deploying to Google Cloud Run
See deploy/gcp/README.md for scripts that deploy
http-server to Cloud Run (capped at 1 instance) with an automated budget
kill-switch that scales the service to zero if spend reaches a configured
threshold (default $2).
Environment Variables
Copy .env.example and adjust as needed.
Key values:
SOFIA_CKAN_BASE_URLHOSTPORTMCP_HTTP_PATHREQUEST_TIMEOUT_MS=30000PREVIEW_MAX_BYTES=262144MAX_SEARCH_RESULTS=50CACHE_TTL_MS=300000— in-memory TTL cache for CKAN reads (groups, organizations, search results, dataset lookups). Set to0to disable caching.ALLOWED_HOSTS/ALLOWED_ORIGINS— comma-separated extra hostnames/origins (beyond127.0.0.1/localhost) allowed to reach the MCP endpoint. Required when deploying publicly (e.g. Cloud Run) so the server's own DNS-rebinding/CORS protection doesn't reject requests to its own public hostname. Left unset, the server only accepts local traffic.MCP_UPSTREAM_URLMCP_SERVER_URL
Tools
search_datasetsget_datasetlist_groupsget_grouplist_organizationsget_organizationlist_dataset_resourcespreview_resourcesummarize_datasetfind_related_datasetsfacet_datasets— returns catalog-wide counts (group/organization/format/license) computed by CKAN's native faceting, not a client-side count over a capped page of results
Dataset Metadata Enrichment
Dataset summaries include a semanticProfile field generated generically from CKAN
metadata alone (groups, tags, resource formats) — there is no per-dataset hardcoded
knowledge to maintain, so it scales automatically as datasets are added or renamed on the
portal. For exact field-level structure, use summarize_dataset or preview_resource,
which parse an actual sampled resource (JSON/GeoJSON) to report real geometry types and
property/field names.
Group names that were corrupted by a source-side Cyrillic transliteration/encoding bug
(e.g. bnopa3hoo6pa3ne) are automatically repaired using a generic transliteration of the
group's title, rather than a hardcoded name-to-name mapping.
Testing
Each package has a unit test suite using Node's built-in test runner:
pnpm test
CI runs pnpm build, pnpm check (typecheck), and pnpm test on every push/PR to main
(see .github/workflows/ci.yml).
Automated dependency updates
Dependabot (.github/dependabot.yml) checks weekly for updates to npm/pnpm packages,
GitHub Actions, and the Docker base image, grouping patch/minor updates into a single PR
per ecosystem. .github/workflows/dependabot-auto-merge.yml automatically approves and
enables auto-merge for patch/minor version PRs; the merge only completes once the
required build-and-test CI check passes on that PR (enforced by branch protection on
main). Major version bumps are left for manual review.
Notes
- Technical naming is English-only.
- CLI display text is bilingual and rendered as two lines with English first.
- Source metadata from the portal is preserved as published.
Sofia Data MCP questions
What tools does Sofia Data MCP provide?
It exposes 11 tools, including search_datasets, get_dataset, list_groups, get_group, list_organizations.
Does the server require authentication?
No, the deployed server is public and does not require authentication.