lagun 0.1.21

A web-based MySQL/MariaDB GUI editor

Lagun

A minimal, web-based MySQL/MariaDB GUI editor. Install it, run it, use it.

Features

• Web-based SQL editor with syntax highlighting, autocompletion, and multi-tab support
• Multi-statement execution — run multiple statements at once, each result shown in its own sub-tab
• Schema browser — explore databases, tables, columns, and indexes; resizable sidebar
• Schema management — create, modify, and drop tables, columns, and indexes
• In-line data editing — edit cells, insert rows, delete rows directly in the grid
• Import & export — CSV and SQL formats with streaming for large datasets; export respects active column filters
• Query history — full SQL with word wrap, copy or load any entry back into the editor
• Bookmarks — save and organize frequently used tables
• Connection management — import and export connection configs
• Secure connections — SSL/TLS, credentials stored in OS keyring, encrypted session backup
• LDAP/AD authentication — optional, via ldapgate

Install

pip install lagun

Usage

lagun serve

Opens the GUI in your browser. Connect to any MySQL or MariaDB database from there.

Options:

--host TEXT          Bind host. [default: 127.0.0.1]
--port INTEGER       Bind port. [default: 8080]
--no-open            Don't open the browser automatically.
--ldap-config PATH   Path to ldapgate YAML config to enable LDAP authentication.

LDAP Authentication

Lagun can require users to log in via LDAP/AD before accessing the editor. This uses ldapgate as FastAPI middleware — no separate proxy process needed.

pip install 'lagun[ldap]'
lagun serve --ldap-config /path/to/ldapgate.yaml

For direct local HTTP usage, set proxy.secure_cookies: false in the ldapgate config. Keep secure_cookies: true in production and run Lagun behind HTTPS with trusted_proxies configured so LDAPGate can honor X-Forwarded-Proto.

When LDAP is enabled, a logout button appears in the top-right corner of the tab bar.

See the ldapgate README for config file documentation.

Screenshots

Development

Requires uv.

git clone https://github.com/anudeepd/lagun
cd lagun
uv sync
uv run lagun serve

License

MIT