Levirge DevOps · plugin

MySQL / MariaDB

Query MySQL or MariaDB behind a firewall through the outbound devops-client, without opening a port to the database.

Levirge DevOps is in private testing, with no public devops-client download yet.

The MySQL / MariaDB data viewer: the schema list on the left with Tables, Views, Indexes, Functions and Queries, an orders table open in its own tab, a filter and resize handle on each column header, and paging in the footer.

Illustrative mock-up with made-up data, not a screenshot.

Features

  • Run SQL queries
  • Browse databases and tables
  • View table data
  • Filter table data by column
  • Export query results
  • Query time and row count with every result
  • Resize table columns by dragging; widths are kept when you reopen the table
  • Interactive SQL console
  • Cancel a running query

For AI agents (MCP)

Connect Claude or another MCP client to Levirge DevOps and the agent can work with this plugin directly.

  • find_connection finds the right connection by name or type.
  • get_sql_schema returns tables and columns. The schema is also offered as an MCP resource, so clients can cache it.
  • run_query runs SQL and pages through large results. Reads work for every role; writes need a role that allows them, and the reply flags any statement that changed data.
  • list_saved_queries returns your saved queries, ready to run.
  • The explain_query prompt has the agent explain a query plan with EXPLAIN ANALYZE.
  • Changes an agent makes are recorded in the audit log as assistant actions.

Capabilities

  • Built for MySQL 5.7 and 8.0 or later, and MariaDB 10.5 or later. Older versions aren't tested.
  • MariaDB is its own connection type. Schema browsing uses MariaDB's own system tables, so MariaDB-specific types show correctly.
  • A connection can be set read-only, for example for a replica. devops-client then refuses writes.
  • Writes from the web UI ask for an authenticator code first.
  • Passwords stay in devops-client's environment on your machine.

Limits

  • The server must be reachable from the machine running devops-client.
  • On a MariaDB Galera Cluster, devops-client connects to a single node.
  • LOAD DATA INFILE and SELECT INTO OUTFILE aren't available.