pg-sharding/spqr

View on GitHub

Stateless Postgres Query Router.

Stars: 1.5k
Forks: 98
Open beginner issues: 0
Indexed issues: 54
Avg merge: 18h 52m
Merged PRs (30d): 93

Dominant language: Go
License: No license data
Last GitHub push: Sep 16, 2026
Latest indexed: Sep 17, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue help wanted

Open All

53 open issues indexed

SPQR Kubernetes Operator Open

enhancement

pg-sharding/spqr#571 · 0 comments · 2 reactions · 0 assignees · Indexed Sep 17, 2026
Looking for collaborators Open

help wanted

pg-sharding/spqr#792 · 0 comments · 2 reactions · 0 assignees · Indexed Sep 17, 2026
Implement SHOW __spqr__distribution Open

enhancement good first issue

pg-sharding/spqr#1031 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
curl https://pg-sharding.com/ | sh Open

must-fix

pg-sharding/spqr#1032 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Test SPQR Router config reload Open

documentation go good first issue

pg-sharding/spqr#1050 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
DROP TABLE with schema does not work Open

bug

pg-sharding/spqr#1071 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Unknown hint works Open

bug enhancement good first issue

pg-sharding/spqr#1083 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
SQL callable function to invalidate local routing metadata cache Open

enhancement spqr-console

pg-sharding/spqr#1159 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Pool rollback does not take effect. Open

bug enhancement

pg-sharding/spqr#1206 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
admin-port does not work without proper frontend config Open

enhancement go

pg-sharding/spqr#1235 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Better error messages for object not exists Open

enhancement go good first issue spqr-console

pg-sharding/spqr#1321 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Support distribution-style syntax for reference relation drop Open

under-discussion

pg-sharding/spqr#1323 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Server lifetime/server idle max wait time Open

enhancement go

pg-sharding/spqr#1332 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Support insert values() proreply Open

enhancement

pg-sharding/spqr#1353 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 17, 2026
Router should not do random-shard for non-ro queries Open

pg-sharding/spqr#1385 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
Real query cancelling support in spqr-console Open

under-discussion

pg-sharding/spqr#1389 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Improving perfomance for generating next sequence value. Open

enhancement go

pg-sharding/spqr#1441 · 4 comments · 1 reaction · 0 assignees · Indexed Sep 17, 2026
Proper multistatement support Open

enhancement go must-fix

pg-sharding/spqr#1487 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
`DBPool.evaluateTSAMatch` should return score instead of bool Open

enhancement

pg-sharding/spqr#1552 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
__spqr_auto_distribution does not write data to QDB in coordinated installations Open

bug

pg-sharding/spqr#1579 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Lack of diagnostics during `REDISTRIBUTE KEY RANGE` Open

enhancement good first issue help wanted spqr-console

pg-sharding/spqr#1630 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Support timestamp with timezone type Open

enhancement go good first issue

pg-sharding/spqr#1657 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Update Get Started Guide Open

documentation

pg-sharding/spqr#1700 · 0 comments · 1 reaction · 1 assignee · Indexed Sep 17, 2026
Unify CLI command style between `spqr-router` and `spqr-coordinator` Open

enhancement go good first issue

pg-sharding/spqr#1715 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
wait for replica cathup in (at least) regression test Open

pg-sharding/spqr#1751 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
SPQR metrics Open

documentation

pg-sharding/spqr#1778 · 0 comments · 1 reaction · 1 assignee · Indexed Sep 17, 2026
Enum type Open

enhancement go spqr-console

pg-sharding/spqr#1843 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Documentation KEY RANGE concept Open

under-discussion

pg-sharding/spqr#1887 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Add documentation for __spqr__ special functions Open

documentation

pg-sharding/spqr#1918 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Support aggregate functions (COUNT, SUM, AVG, MIN, MAX) across distributed shards Open

enhancement go

pg-sharding/spqr#1931 · 1 comment · 2 reactions · 0 assignees · Indexed Sep 17, 2026
Feature: Automatic Key Range Distribution Open

enhancement go spqr-console

pg-sharding/spqr#1959 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Feature: Auto-rebalancing for Key Ranges Open

enhancement go spqr-console

pg-sharding/spqr#1960 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Feature: Improve Error Messages Open

go good first issue spqr-console

pg-sharding/spqr#1966 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
`SHOW task_group` displays `RUNNING` status after coordinator crash Open

pg-sharding/spqr#1982 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
Unexpected `ERROR: move task stopped by STOP MOVE TASK_GROUP command` when RETRY TASK GROUP Open

pg-sharding/spqr#1983 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Remove `HASH` keyword from `CREATE RELATION` / `ATTACH RELATION` Open

go spqr-console

pg-sharding/spqr#2010 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Demo applications for popular languages and drivers Open

documentation

pg-sharding/spqr#2018 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
SPQR Admin: key-range topology and data-movement visualization Open

under-discussion

pg-sharding/spqr#2021 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Verify SPQR works with various database clients Open

test

pg-sharding/spqr#2032 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
Route requests to healthy shards when one of shards is unreachable Open

under-discussion

pg-sharding/spqr#2235 · 8 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
spqr returns query result in text format, instead of requested binary Open

bug

pg-sharding/spqr#2430 · 3 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
Better isolation test coverage for basic features. Open

pg-sharding/spqr#2495 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Validate router transaction/shard statement time quantile accuracy. Open

pg-sharding/spqr#2496 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Reorganize feature tests Open

pg-sharding/spqr#2500 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Document missing yacc console commands in generated HELP/docs Open

documentation

pg-sharding/spqr#2570 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
etcdqdb: exact key match guard missing in most Get calls (prefix collision bug) Open

denchick

pg-sharding/spqr#2590 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
UUID binary bind params may be parsed incorrectly Open

under-discussion

pg-sharding/spqr#2591 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
Data race / concurrent map access on QueryStateExecutorImpl.localConn during relay close Open

pg-sharding/spqr#2772 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 17, 2026
[ci-flaky] router-regress_router-6432 / target_list_routing (cross-matrix) Open

agent:flake-fix ci-flaky

pg-sharding/spqr#2913 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026
[ci-flaky] Test integration with spqrguard / spqrguard is set up correctly [15] Open

agent:flake-fix ci-flaky

pg-sharding/spqr#2915 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 17, 2026

pg-sharding/spqr

Get new issues in your inbox