Tools — Keel Database Proxy

Pool Size Calculator

Estimate the optimal min_pool_size and max_pool_size for your workload. Results are updated live as you adjust the sliders.

Concurrent App Clients

200

Total simultaneous connections from your application layer

Avg Query Duration (ms)

20ms

Mean time a backend connection is actively running a query

Target Multiplexing Ratio

10×

How many app clients share each backend connection

Pool Mode

pool Transaction pooling smart R/W routing proxy 1:1 passthrough

Number of Workers

Set to 0 in keel.ini for auto (matches CPU cores)

min_pool_size

per worker

max_pool_size
20
per worker

Total Backend Conns

workers × max_pool

Multiplexing

10×

app clients / pool

Connection Distribution

App Clients

200

Max Pool (total)

Min Pool (warm)

Generated keel.ini snippet

Configuration Builder

Step through the wizard to generate a complete keel.ini. The live preview updates on every change.

Protocol

Mode

Network

Pool

Backend

Select Protocol

PostgreSQL PostgreSQL v3 wire protocol (port 5432)

MySQL MySQL client/server protocol (port 3306)

Select Runtime Mode

pool Stable Transaction pooling + prepared-statement virtualization. Recommended for production.

smart Hardening Adds R/W routing, SQL analysis, and backend state sync.

full Experimental All features including hooks, XID tracking, and WAL LSN capture.

proxy Pure passthrough — no pooling. Useful for TLS termination only.

Network Settings

Bind Address

Listen Port

Admin/Metrics Port

Workers (0 = auto)

0 = one worker per CPU core (recommended)

Enable TLS

Pool Settings

Min Pool Size

Per worker

Max Pool Size

Per worker

Idle Timeout

Pool Wait Timeout (ms)

Prepared Statement Strategy

Backend Servers

Server 1

Name

Role

Host

Port

Weight

Database

User

✓

Config Generated!

Your keel.ini is ready. Copy it from the preview panel.

keel.ini — Live Preview

Query Router Simulator

Paste any SQL query and see where Keel would route it. Simulates the smart/full mode routing logic including R/W splitting and sharding rules.

SQL Query

Runtime Mode

Replicas Available

Inside open transaction (BEGIN)

Sharding enabled

Quick examples:

Enter a SQL query and click Analyze Routing

Keel Toolbox