Romania's company registry has no free API — so I built one (4.2M firms, MCP + REST)
说明与用途
为罗马尼亚公司注册表构建 API 的指南:将大型 CSV 转换为快速 SQLite 数据库,支持全文搜索,并通过 REST 和 MCP 接口公开。
问题
Romanian company registry data is available only as large CSV dumps with no programmatic query interface, hindering efficient data retrieval for lead‑generation tools.
结果
The project transforms raw ONRC CSV dumps into a 3.5 GB SQLite database with fast, diacritic‑aware search, accessible via REST and MCP, enabling rapid company data retrieval for AI agents.
工作流
- Download monthly CSV dumps from data.gov.ro
- Stream CKAN CSVs into SQLite using load_onrc.py
- Load CAEN and status decode tables with load_nomenclatoare.py
- Load 2025 financial statements keyed by CUI with load_financiare.py
- Create diacritic‑insensitive FTS5 index for fast search
- Expose data through REST API (onrc-api.adrianhomelab.com) and MCP server (hermes.adrianhomelab.com/mcp)
- Implement monetization flag for paid financial data
证据
Romania publishes its entire registry as open data. Every month, data.gov.ro drops a snapshot: 4,196,860 companies, 19.3M CAEN activity records, 3.68M legal representatives, 4.64M status entries.
I built an FTS5 full‑text index with diacritic‑insensitive folding: ă â î ș ț fold to a a i s t on both the index and the query.
I exposed it two ways: A REST API (onrc-api.adrianhomelab.com) and an MCP server (hermes.adrianhomelab.com/mcp).
- 记录日期: 2026-09-14T06:15:33.231Z