kingshard
kingshard: A focused, self-hosted MySQL proxy with broad routing and sharding controls. Ranked #17 of 31 in Database Proxy Software by our editors (7.5/10); pricing: Open source; best for open-source MySQL sharding.
At a glance
- Editor score7.5 / 10
- PricingOpen source
- Best forOpen-source MySQL sharding
- Paid fromFree
- Deployment modelSelf-hosted
- Facts checked20 Sep 2026
Where it wins
- Supports hash, range, and date sharding
- Combines pooling, routing, and read load balancing
- Includes backend health handling and access controls
Where it doesn't
- Self-hosted deployment requires operational ownership
- Supports MySQL rather than multiple database systems
- Transactions are limited to single-node operations
Our verdict on kingshard
kingshard is an open-source MySQL proxy written in Go for teams operating MySQL clusters. It sits between applications and MySQL servers, handling read/write splitting, connection pooling, read load balancing across slave servers, SQL routing, and sharding. Its feature set suits teams that want to divide database workloads across nodes while keeping proxy-level controls for prepared statements, backend status, IP access, and SQL filtering.
Its strongest area is breadth within MySQL sharding and traffic management. kingshard supports hash, range, and date sharding, along with routing SQL to specified nodes. Connection pooling can help centralize application connections, while read balancing distributes reads across slave servers. Prepared statement support and common SQL operations broaden its application fit. Backend health and high-availability handling, including dynamic backend status changes, add operational controls for clustered deployments. The project also provides IP access control and a SQL blacklist for defined access-management needs.
The trade-off is a focused, self-hosted operating model. Teams deploy the project themselves from source and remain responsible for running the proxy alongside their MySQL infrastructure. It is designed around MySQL rather than a multi-database environment, and transaction support is described for single-node transactions. kingshard is a suitable choice for teams that want an open-source MySQL proxy with sharding, routing, pooling, and read balancing in one deployment. Teams seeking a managed service, broader database coverage, or a platform outside self-hosted operations should choose an alternative.
Your product? Our editors can test kingshard in depth and publish a review, labelled as paid · from $149/mo →
kingshard pricing
kingshard fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Deployment model | Self-hosted |
| Connection pooling | Yes |
| Query routing | Yes |
| Load balancing | Yes |
| Automatic failover | Yes |
| Supported databases | MySQL |
| Maximum connections | Not verified |
| Deployment | Self-hosted |
| Support | Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Open source |
| Website | github.com |
| Facts checked | 20 Sep 2026 |
Alternatives to kingshard
- Heimdall Database ProxyA broad database proxy with pooling, routing, analytics, security, and failover.9.4
- ProxySQLA free, open-source proxy for routing, pooling, balancing, and managing database traffic.9.2
- ShardingSphere-ProxyA self-hosted proxy for routing, scaling, and high availability across four database protocols.9.0
See all kingshard alternatives →
Also Ranked In
kingshard is ranked in 2 of our directories.
Used kingshard? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used kingshard for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
kingshard is listed in our Database Proxy Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/kingshard/"><img src="https://www.itechguides.com/best/badge/kingshard.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update