Skip to content
govern
Start exploring

A local workspace for curious minds

Your data.Your next idea.

Follow real records and their connections. Compare what matters, bring in your data and turn questions into SQL, all in one local workspace.

Local by designExplore without SQL

Runs locally with Docker. Stays on your machine.

Meet your workspace

Less searching. More understanding.

Switch views, choose a table and follow a record. This little store is yours to explore.

governdemo_storeLocal connection
Tools
Where to find workspace tools

A guide to the real menu. Open the workspace to use these tools.

Second screen & record windowsLocal AI & project code searchLanguage, account & database tools

Database

Sample workspace

Scroll sideways to see the full schema or table.

Tables

users

♢ idINT

nameVARCHAR(255)

created_atDATETIME

orders

♢ idINT

user_idINT

created_atDATETIME

order_items

♢ idINT

order_idINT

product_idINT

quantityINT

priceDECIMAL(10,2)

products

♢ idINT

nameVARCHAR(255)

priceDECIMAL(10,2)

created_atDATETIME

Try the views. Follow a connection.demo_store

Illustrative workspace · sample data

From curiosity to clarity

See the connections.Find your own direction.

Explore your schema. Keep your SQL. Make room to experiment.

01 / Explore

Start with a record and follow its real connections on a flexible canvas.

02 / Query

Write, run, and save SQL.

03 / Experiment

Create named SQL restore points.

A place for every part of your work

From a table to the story behind it.

Start with a record. Follow its connections. Keep the details you need beside you, without writing SQL.

  1. Choose your starting point

    Choose a database in the top bar. Open Database → Explore, open Sources, then choose a table and search for a record.

  2. Follow a real connection

    Select a record and expand a connection, or use a suggested question to show linked records. Select a line to inspect matching fields, values and source SQL.

  3. Make room to think

    Drag cards, pan and zoom, or choose Orbit or Flow to arrange the canvas. Pin cards, filter tables, hide cards and undo presentation changes.

Explore only reads records. Moving or hiding a card never edits or deletes its source. Connections follow declared foreign keys; the map loads only the records you request.

Explore controls at a glance
Select & inspect
Select a card for its record or a line for its source evidence. Shift-select adds cards to your selection. View row opens the source in Records; Explore from here continues from the selected record.
Arrange & focus
Orbit and Flow rearrange cards. Manual keeps your arrangement; Pin keeps a card in place during rearrangement. Hide and table filters affect only the canvas. Show all loaded records brings hidden loaded cards back.
Keep your workspace clear
Move, resize or close Sources and the inspector to make space. On a small screen, one panel opens at a time. Canvas actions also have buttons and keyboard controls.
Undo & start again
Undo restores a previous canvas presentation. Clear map empties the loaded map and cannot be undone. Neither changes the database. Load another page explicitly when a connection has more records.

Know where to go next.

Records & Schema

The rows and the bigger picture. Find a value, inspect a field, understand how your tables fit together.

How to use it

Use Records to browse, search and edit MariaDB rows. Schema shows table details, columns, keys and a diagram of table relationships. Explore follows individual records within that structure.

Record windows & a second screen

Keep one record in view while you follow the next. Make space for a closer comparison.

How to use it

Choose Open in window to keep records side by side in draggable windows. In the top Tools menu, open Second screen: pin up to four records on the Comparison desk, or let the Relationship radar follow your selection. Two windows on one monitor work too.

Each window keeps its original source. Comparison pins last until the companion window closes or reloads.

The top Tools menu

A quieter top bar. The tools you need, together in one place.

How to use it

The database selector sets your workspace context. Tools groups the selection pointer, second screen, local AI, refresh, context export, database creation/import, language and your account. Settings holds appearance and layout preferences.

Turn on the selection pointer to inspect a control or data item without activating it. Shift-click combines selections; More explains the selection.

Database → Tools is for import, export and backups. The top Tools menu contains workspace-wide controls.

Bring in your data

From a spreadsheet to something you can explore. Preview first, then choose where your data belongs.

How to use it

For MariaDB, choose Open database → Import files for CSV, TXT/TSV, Excel (.xlsx), JSON or ZIP archives containing these files. Preview the file, choose a sheet and destination, then confirm the database. SQL import offers preflight and post-import checks; official phpMyAdmin remains available for larger SQL files and database administration.

Importing can change data. A file import does not create relationships automatically. Create a restore point before changes you may need to reverse.

SQL & restore points

Turn a question into a query. Save your research and keep a restore point before the next experiment.

How to use it

Research lets you build a read query visually or write, run and save SQL yourself. Use Database → Tools → Backups to create, download and restore MariaDB restore points. Restore replaces that database; an import or SQL script has no universal undo.

Local AI, when you want it

A little help, on your terms. Optional local AI and source-based project search, right beside your work.

How to use it

Explore works without AI, which is off by default. If you configure local Ollama, the assistant can explain schema context and propose SQL for Research. Project code search shows local files and source lines, even with AI off. Model answers never execute SQL automatically.

Before you begin.

A few practical things, before you make it your own.

Can I use PostgreSQL?

Yes. Enable the optional PostgreSQL connection to browse records, search, inspect Schema and use Explore. With its separate writer connection you can add, edit and delete records. Free SQL, imports, restore points, AI and phpMyAdmin currently belong to MariaDB.

PostgreSQL setup
Who can open my workspace?

The first account becomes the installation owner. Later registrations need approval in Account → Access requests. Approved accounts share that installation’s database access.

What is kept when I leave?

Database records, saved research, restore points and accounts stay in Docker volumes. Language, appearance and dashboard layout stay in your browser. Explore maps, comparison pins and AI conversations are temporary; reloading starts a new session for them.

On your machine. On your terms.

Be here atthe beginning.

Try Govern. Share an idea. Help shape what comes next.

MariaDB · Optional PostgreSQL · Docker Compose · Optional local AI

Each installation has its own accounts. Your account opens this workspace; your databases stay in your Docker installation.

Create an account

A workspace of your own

Start something locally.

Choose your system and installation type. Run the commands in PowerShell on Windows, or a terminal on macOS/Linux. The first launch builds Govern and creates local credentials.

Install Git and start Docker Desktop with Linux containers. You do not need to install PHP, Node or a database separately.

These commands use the combined workspace branch, including Explore, windows and Tools.

PowerShell
git clone --branch integrate/all-govern-updates https://github.com/Esmeevanleeuwen/govern.git
cd govern
.\start.cmd

Then open localhost:8080 and sign in, or create the first owner account for a new installation.

Read the full setup guide

Sample workspace

A little room to explore.

This preview uses a fictional store. Choose Records, Explore, Table details or Schema and select a table. In Explore, select a linked record to follow its connections. The preview does not connect to your databases or run SQL.

Create an account to open this installation, or run Govern locally for a workspace of your own.

Make it your workspace