← Back to portfolio

EGRUL Database — 22M+ Russian Companies

2017 PHP · Laravel · Gov API · Postgresql

EGRUL is the official Russian registry of legal entities and individual entrepreneurs. I built a service that hosts the entire database — over 22 million records — with full-text search, a visual query builder, API access, and scheduled data exports via webhooks.

The query builder

The killer feature is the query constructor. You build filters visually: pick a field (OKVED code, entity type, status, city), choose an operator (equals, contains, like), set a value, and stack as many conditions as you want with AND/OR logic. Hit "Execute query" and get a table of matching companies. It's basically a no-code interface for writing SQL against the EGRUL database.

Query builder — filter by OKVED, entity type, status, city

Search results table — company name, type, status, registration date, INN

Scheduled exports

Found a useful query? Save it and schedule automatic delivery. The planner lets you pick a saved query, set the action (send CSV to email), choose the time and days of the week. Every Monday at noon, you get a fresh list of, say, all active construction companies in Moscow. Sales teams loved this.

Data export scheduler — query, user, action, schedule by weekday

Pricing and API

The platform runs on a tiered pricing model. Each tier defines monthly and daily limits for simple and complex queries, and whether webhooks are allowed. There's also a raw API for developers who want to integrate EGRUL data directly into their own systems.

Tariff management — request limits by type and tier

We kept the database in sync with the official Federal Tax Service source, updating it regularly. At peak, we had hundreds of active users — mostly B2B sales teams, legal firms, and fintech companies doing due diligence.