UrSchema — Database Management Simplified

A database manager that lives on your own server.

UrSchema is a self-contained, single-binary app for browsing, querying, and managing MySQL, PostgreSQL, and SQLite databases — no cloud account, no external requests, credentials encrypted at rest on your own machine.

Open source · MIT licensed · Go + Vue, no telemetry

Everything you need to run a database, nothing you don't

A visual database experience similar to Navicat or DBeaver, built for server operations.

🔐

Connection Management

  • AES-256-GCM encrypted credential storage
  • Multiple concurrent connections
  • One-click connection testing
  • Server-side file browser for SQLite
📊

Data Operations

  • Paginated grid & form views
  • Inline editing, in place
  • Add / delete rows with batch commit
  • Safe CRUD, with or without primary keys

SQL Query

  • CodeMirror 6 SQL editor
  • One-click SQL formatting
  • Query history with re-run
  • Multi-statement execution
🏗️

Table Designer

  • Visual columns / indexes / foreign keys
  • Live DDL preview with diff
  • Auto-generated ALTER statements
📤

Import / Export

  • mysqldump-compatible + pure-Go fallback
  • CSV / JSON / SQL table exports
  • Real-time task progress tracking
📈

Database Overview

  • Row count, size & engine at a glance
  • Object search & filter
  • Quick DDL preview & copy

How it runs

One binary. One process. Your infrastructure, not ours.

1

Download a single binary

UrSchema ships as a self-contained Go binary with the UI built in — no separate install step, no dependencies beyond the databases you connect to.

2

Run it anywhere

Bare metal, a VM, or your laptop. It serves its own web UI over HTTP — open it in a browser, no other services required.

3

Connect & go

Point it at MySQL, PostgreSQL, or SQLite. Credentials are encrypted at rest with AES-256-GCM and never leave your server.

Get UrSchema

Build it yourself today — prebuilt releases are on the way.

Linux amd64 Linux arm64 macOS — soon Windows — soon
# clone & build from source
git clone https://github.com/virlatinus/UrSchema-Community.git
cd UrSchema/backend
make package
View source on GitHub