Table editor
Click a table and edit rows like a spreadsheet. Insert, update, and delete with primary-key safety, pagination, sorting, and NULL controls.
CRUDPrimary keysPagination
Local-first database console
Your H2 database, local-first and tailnet-ready.
HySQL gives you a fast desktop console for H2. Create databases, edit rows, run SQL, share over Tailscale, and publish with Funnel when you choose.
Local by defaultH2 binds to 127.0.0.1 only
H2 2.3.232Pinned engine included
Tailscale readyTailnet and Funnel hosting
Java supportHikariCP, JDBC, Spring Boot
Everything in one console
A database manager that respects the local machine.
HySQL keeps the engine on loopback, adds sharing only when you ask for it, and gives you the everyday tools to work with H2 without a separate admin stack.
SQL workbench
Run one statement at a time, inspect columns, and jump from the schema tree to a generated SELECT. Results are capped at 500 rows.
Ctrl+EnterSchema tree500 rows
Tailscale hosting
Share a database with your tailnet through a loopback-to-tailnet proxy. Watch active peers and throughput live.
MagicDNSACLsLive metrics
Public Funnel
Expose a database on the internet with Tailscale Funnel on ports 443, 8443, or 10000. Clear warnings and automatic cleanup keep exposure deliberate.
Port 10000Auto cleanupPublic URL
Java connectivity
Generate Maven, Gradle, HikariCP, Spring Boot, and raw JDBC snippets with the active credentials and endpoint.
HikariCPJDBCSpring Boot
Crash recovery
Validate persisted PIDs, adopt healthy H2 servers, and find untracked processes that still hold a database file before starting again.
AdoptionOrphan cleanupProcess trees
Table editor
Edit data without writing SQL.
The table editor keeps everyday changes in one place. The schema tree stays on the left, the grid stays on the right, and every write goes through a validated SQL statement.
- Primary-key aware edits. Update and delete identify a single row.
- Pagination and sorting. Choose 25, 50, or 100 rows per page.
- NULL and default controls. Omit a value to let H2 supply the default.
- Safe column handling. Identity, generated, and view columns are treated correctly.
- No silent truncation. Values above the display cap are never saved back by accident.
Sharing
From loopback to tailnet to the public internet.
H2 always binds to 127.0.0.1. HySQL adds sharing only when you turn it on, and each step is a separate choice.
Local
127.0.0.1:9093
The H2 engine stays on loopback. Local work needs no network setup.
→
Tailnet
100.x.y.z:19093
A proxy on the Tailscale interface for peers allowed by your ACLs.
→
Public internet
node.tailnet.ts.net:10000
Tailscale Funnel exposes the raw H2 TCP port to anyone on the internet.
Funnel is public. Raw Funnel TCP is not encrypted in transit, and the H2 password is the only access control. Use a strong password, share only what you intend to share, and disable Funnel when you are done.
- Allowed ports only. Funnel uses 443, 8443, or 10000. Port 10000 is the default.
- Cleanup on normal actions. Hosting is removed when the database stops, restarts, is deleted, or the app exits cleanly.
- Crash reconciliation. A leftover Funnel mapping is checked on the next launch.
- Independent choices. Tailnet hosting and public Funnel can be enabled separately.
Java connectivity
Connect from Java in minutes.
HySQL generates copy-ready connection code for local and tailnet modes, using the credentials stored on this machine. Switch modes and the snippets update.
HikariCP
JDBC test
Maven
Gradle
Spring properties
Spring YAML
- Two connection modes. Loopback for local tools and Tailscale for allowed peers.
- No copy mistakes. Ports, database names, users, and passwords are filled in for you.
- Verified output. The generated HikariCP and raw JDBC programs are compiled and tested against H2.
Quick start
From download to first query in three steps.
Install HySQL
Download the Windows setup, run it, and launch HySQL. Java 11 or newer is required, and the H2 engine is included.
Create a database
Pick a name and a password. HySQL starts a loopback H2 server on the next free port and stores the database under ~/.hysql.
Edit, query, share
Open the Table Editor, run SQL, or enable Tailscale hosting when you need remote access. The docs cover every screen.
Get HySQL 0.3.0 for Windows.
The installer includes the H2 engine. Tailscale is optional, and your databases stay on your machine.
The installer is unsigned, so Windows SmartScreen may ask you to confirm before running it. The source code is public on GitHub.