Sofia Data MCP server
Commit 10 Nov 2026Memungkinkan AI client untuk mengakses dan melakukan query pada dataset perkotaan dari portal pemerintah kota Sofia melalui integrasi CKAN.
Juga dikenal sebagai manevpe/sofia-data-mcp
- Stars
- 0
- Tools
- 11
- Unduhan, 30 hari
- —
- Versi terbaru
- —
- Commit terakhir
- 10 Nov 2026
- Lisensi
- MIT
Apa itu Sofia Data MCP?
Memungkinkan AI client untuk mengakses dan melakukan query pada dataset perkotaan dari portal pemerintah kota Sofia melalui integrasi CKAN. Server ini menyediakan 11 tool, seperti search_datasets, get_dataset, list_groups.
Ringkasan dibuat dari README proyek
Tentang Sofia Data MCP server
Server ini memungkinkan developer dan analis data untuk melakukan query pada dataset perkotaan dari portal pemerintah kota Sofia. Dengan berintegrasi langsung ke CKAN Action API, server ini menyediakan interface bagi AI client untuk mengeksplorasi informasi kota melalui tool seperti search_datasets, list_groups, dan get_dataset. Sistem ini dirancang untuk menangani metadata yang kompleks, termasuk perbaikan otomatis pada nama grup Cyrillic yang korup serta profiling semantik berdasarkan tag dan format.
Anda dapat terhubung melalui endpoint HTTP publik untuk dukungan native di Cursor atau VS Code Copilot Chat. Untuk client yang terbatas pada proses lokal seperti Claude Desktop, server ini menyediakan stdio bridge yang meneruskan request ke URL remote. Server ini memerlukan Node.js 24+ dan dapat dijalankan secara lokal via pnpm atau dideploy ke Google Cloud Run. Server ini juga menyertakan in-memory cache untuk pembacaan CKAN guna meningkatkan performa serta mengelola data melalui tool spesifik seperti facet_datasets dan preview_resource untuk memeriksa konten JSON atau GeoJSON.
Apa yang bisa Anda lakukan dengannya
- 1Cari dataset pemerintah kotaAI agent dapat menemukan file data perkotaan tertentu dengan mencari di katalog pemerintah kota.
- 2Analisis distribusi dataAnda dapat meminta jumlah dataset yang dikategorikan berdasarkan lisensi, format, atau organisasi.
Ditulis berdasarkan README proyek. Setiap use case diperiksa terhadap kutipan dari README tersebut.
Tool Sofia Data MCP 11
Terdeteksi dari 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 | — |
Konfigurasi
E2E_BASE_URL
| Nama | Deskripsi | Tipe |
|---|---|---|
| E2E_BASE_URL | — |
Pengecekan otomatis
Berjalan 14 Nov 2026Laporan lengkap →Belum diverifikasi. Sebuah server memerlukan skor 80, tidak ada temuan serius, dan data yang cukup untuk kami periksa. Cara kerja checks · Yang perlu diperbaiki untuk menambah poin
- Source repository terhubung dan dapat dijangkaumanevpe/sofia-data-mcp is public and reachablegithub.com/manevpe/sofia-data-mcp ↗Lolos
- Nama paket mencantumkan repositori ini sebagai sumbernyaTidak diperiksa
- Provenance build (atestasi Sigstore)Tidak diperiksa
- Lisensi open source (OSI)MITspdx.org/licenses/MIT.html ↗Lolos
- Ada commit atau release dalam satu tahun terakhirLast commit or release 2026-11-10github.com/manevpe/sofia-data-mcp ↗Lolos
- OpenSSF ScorecardTidak diperiksa
- Nama package tidak mirip dengan package populerTidak diperiksa
- Tidak ada advisory kritis pada paket atau dependensinyaTidak diperiksa
- Tidak ada instruksi tersembunyi untuk model11 tool descriptions and the README read; no override phrases, credential paths or hidden charactersLolos
- Tools yang bersifat destruktif telah diberi labelNo tool named like delete, drop or execLolos
- Endpoint remote merespons handshake MCPTidak diperiksa
README
Lihat di 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.
Pertanyaan tentang Sofia Data MCP
Tool apa yang disediakan Sofia Data MCP?
Server ini menyediakan 11 tool, termasuk search_datasets, get_dataset, list_groups, get_group, list_organizations.
Apakah server ini memerlukan autentikasi?
Tidak, server yang dideploy bersifat publik dan tidak memerlukan autentikasi.