# spqr

Stateless Postgres query router.

Source: [Console review](<https://console.dev/tools/spqr>)

Website: [https://github.com/pg-sharding/spqr](<https://github.com/pg-sharding/spqr>)

Profile updated: 2026-10-16

Category: [Database management](<https://console.dev/tools/categories/database-management>)

## Supported tech stack

Research checked: 2026-10-11

### Integrates with

- Docker (Integration)
- PostgreSQL (Integration)

### Written in

- Go (Language)

Source: [Research source](<https://github.com/pg-sharding/spqr>)

Documented compatibility; coverage may be incomplete. Written in describes implementation, not user-project language support.

PostgreSQL sharding router builds with Go and provides Docker examples.

## Console’s review — 2024-04-04

Reviewed: 2024-04-04

Author: [David Mytton](<https://console.dev/about#david-mytton>)

Citation: [This review](<https://console.dev/tools/spqr#review_1b524e6db1ee9276f7e6d48aa4fa6b4c347a2313408709c1da42f478c08ee3be>)

### What we like

Scale Postgres horizontally by configuring shards. Wire protocol compatible so all existing clients work - they don’t need to be shard aware. Includes connection pooler so you can replace PgBouncer et al. Can run multiple routers for HA. Live config reloading.

### Tradeoffs

Doesn’t support cross-shard queries. Docs are limited - no quick start guide, but browsing the example configs gives you an idea of how to get going.

This review reflects Console’s assessment at publication on 2024-04-04. Features and limitations may have changed since the review date.

## Is spqr a fit?

Based on [Console’s review published on 2024-04-04](<https://console.dev/tools/spqr#review_1b524e6db1ee9276f7e6d48aa4fa6b4c347a2313408709c1da42f478c08ee3be>).

Summary updated: 2026-10-16

### Who it’s for

Developers using Postgres can consider this tool for horizontal scaling

### Why consider it

It allows for horizontal scaling of Postgres by configuring shards

### Keep in mind

It does not support cross-shard queries

[Selection criteria](<https://console.dev/selection-criteria>) · [About Console](<https://console.dev/about>) · [Browse tools](<https://console.dev/tools>)
