Esploro

SQL client for you
and your agents.

Work with PostgreSQL, MySQL, and MariaDB on your Mac.
Connect your agents through the built-in MCP server.

Download for Apple Silicon Intel

macOS 13+ · Version 0.9.2

Free for personal use. Commercial licenses for paid work.

Install with Homebrew
brew install --cask matija/tap/esploro
Esploro table browser with shop tables and order rows. Fictional database data.

Browse. Edit. Query.

Table editor

Filter, edit, and select rows. Copy as JSON or CSV.

Esploro table editor with selected order rows. Fictional database data.

SQL editor

Run queries, inspect results, and save your SQL.

Esploro SQL editor and query results. Fictional database data.
Themes and appearance

Choose your theme, fonts, and row height.

Esploro appearance settings. Fictional database data.
Esploro theme menu. Fictional database data.

Connect your AI agent.

Use Esploro’s local MCP server to inspect schemas and run read-only SQL through your saved connections.

Set up MCP
  1. Save your database connections in Esploro and keep the app running.
  2. Open Settings → MCP. Copy the configuration into your agent’s MCP settings.
  3. Ask your agent to inspect a schema or run a read-only query.
MCP configuration
{
  "mcpServers": {
    "esploro": {
      "type": "http",
      "url": "http://127.0.0.1:19482/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_TOKEN>"
      }
    }
  }
}

Replace <YOUR_TOKEN> with the token from Settings → MCP. Keep it private. Your client must support Streamable HTTP and bearer headers; configuration formats vary.

list_connections
Find saved connection names and IDs without exposing credentials.
inspect_schema
Inspect tables, columns, types, and relationships.
execute_query
Run validated, read-only SELECT queries, including joins and aggregations.

The server listens on your Mac’s loopback address. Its bearer token is stored in Keychain. SQL validation and read-only transactions block writes, with a 30-second timeout and up to 1,000 returned rows. Review the latest 20 query attempts in Settings → MCP Activity.

The MCP token grants access to all saved connections. Use restricted database roles. Read-only access is not complete isolation. Query results can reach your agent’s provider.

Direct connections. Local credentials.

Esploro connects from your Mac to your database. Passwords stay in macOS Keychain. Queries and results do not pass through an Esploro cloud service.

Source code Privacy policy