Skip to content

Truffle

MySQL and PostgreSQL browser and query tool

A web SQL browser for MySQL / PostgreSQL — query, edit, and manage tables without handing out master credentials.

Try live demo REST API docs Pricing
  • Docker container
  • Kubernetes Helm chart
  • 2 database engines
  • 2 auth methods
  • REST API + OpenAPI 3.0.3
  • Realtime WebSocket channels
  • Atlas schema migrations
  • MCP server for AI agents
  • Single Go binary — zero external deps
  • Stateless horizontal scale
Truffle screenshot

Truffle is your database GUI — switch between databases, browse tables, edit rows, run custom SQL, and manage schemas. Inline editing with primary key detection, row insert/update/delete, table operations (create, rename, drop), and a filter builder for WHERE clauses. Perfect for QA verifying data and developers debugging without touching production credentials.

Truffle
What it does

Key features

Multi-engine: MySQL 8+, PostgreSQL 16+

Database switching and schema browsing

Table browser with paginated rows and sorting

Inline row editing with primary-key detection

Row insert, update, delete operations

Custom SQL query editor with results display

Table ops: create, rename, drop

Filter builder for WHERE clause construction

Truffle
Why it's different

Where it goes beyond the obvious

Inline editing with primary-key detection for seamless UX

Tech highlights

  • Engines: MySQL 8+, PostgreSQL 16+
  • Features: schema browser, inline edit, query builder, DDL ops

Built on

database/sqlgo-sql-driver/mysqllib/pqSvelte 5Tailwind 4

REST API surface

  • GET /databases Databases on the server
  • GET /tables Tables in current DB
  • GET /table/{name} Schema incl. primary key
  • POST /table/{name} Create table
  • GET /table/{name}/rows Paginated rows with filter + sort
  • POST /table/{name}/rows Insert
  • PUT /table/{name}/rows/{id} Update by primary key
  • POST /query Execute arbitrary SQL

Full spec at GET /openapi — Swagger UI at /swagger/

Your infrastructure

Backends you can actually pick from.

This service speaks the backends below natively. Swap with a single environment variable.

Databases

  • MySQL 8+
  • PostgreSQL 16+

Auth

  • Bearer token
  • HTTP Basic
Where it fits

Use cases

QA teams verifying database state during testing

Developers debugging data issues without production access

Operations teams managing database contents

Support engineers investigating customer data issues

Learning environments teaching SQL without command-line

vs SQL database browsers

Truffle vs phpMyAdmin / pgAdmin, TablePlus, DBeaver

MySQL and Postgres GUI without handing out master credentials

Compare head-to-head
Patterns

Architecture patterns featuring this service

Ship an internal platform without building plumbing

Hand your team a production-grade platform on day one: object storage, queues, auth, observability — all self-hosted, all wired to the same contract.

Give ops and QA safe database access

Truffle for SQL, Stash for Redis, Depot for object storage — browser-based access with action-level permissions.
Same family

More in storage

Depot

Storage

A web GUI for browsing and managing object storage (S3, MinIO, Azure Blob) without exposing admin credentials to developers.

Multi-engineGrid and list view modes withInline image preview in a detail

Stash

Storage

A web GUI for Redis / Valkey — browse keys by namespace, edit values, delete patterns, and view server stats without admin credentials.

All key typesDatabase switching with expand/collapse for emptyNamespace grouping by colon-separated keys
Ready when you are

Deploy Truffle. Today.

One Docker image. One compose stack. One afternoon to production. Truffle is waiting.

See pricing Browse more services