pg-sharding/spqr

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1465 stars · 96 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

SPQR (Stateless Postgres Query Router) is a production-ready proxy that horizontally scales PostgreSQL via sharding by routing queries to the correct shard at the PostgreSQL protocol level. It is written in Go, stores sharding rules in etcd, and is battle-tested at Yandex Cloud for OLTP workloads.

Use cases

• shard a large postgres database horizontally
• route queries to postgres shards without app-level sharding logic
• migrate a monolithic postgres database to a sharded setup
• scale postgres beyond terabytes of data and 100k queries per second
• automate resharding of an already sharded postgres cluster
• use managed postgres services like AWS RDS as shards behind a router

When to choose

• your data exceeds several TB or vertical scaling has hit its limits
• workload is mostly single-shard OLTP queries with a clear sharding key
• you want a permissively licensed (PostgreSQL license) alternative to Citus or Vitess
• you want to keep using vanilla PostgreSQL instead of another database engine

When to avoid

• you need cross-shard JOINs or multi-shard transactions
• your workload is OLAP or analytical — use Greenplum or similar instead
• your dataset is small enough to fit comfortably on a single instance

Facets

service · maturity active

database routing proxy middleware databases microservices backend self-hosted go self-hosted cloud postgresql sharding query-router oltp connection-pooling horizontal-scaling database-proxy linux docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pg-sharding/spqr")