MindsDB Anton: The Open-Source BI Agent That Actually Builds Dashboards

By Prahlad Menon 4 min read

MindsDB just open-sourced Anton — and it’s not what you’d expect from yet another “AI analytics” tool.

Most AI data tools are glorified SQL generators. You ask a question, they write a query, you get a table. Anton does something fundamentally different: it takes ownership of the entire analytical process. It connects to your data sources, writes Python code to analyze it, and builds full interactive dashboards — all from a single plain-language request.

What Anton Actually Does

Here’s the concrete workflow. You type:

I hold 50 AAPL, 200 NVDA, and 10 AMZN. Get today's prices, calculate my
total portfolio value, show me the 30-day performance of each stock, and
any other information that might be useful. Give me a complete dashboard.

Anton doesn’t have a built-in “stock portfolio” skill. It figures it out live:

  1. Scrapes current stock prices
  2. Writes analysis code on the fly
  3. Calculates portfolio value, concentration risk, correlations
  4. Builds an interactive dashboard with charts
  5. Opens it in your browser
  6. Provides a written summary with actionable insights

The dashboard isn’t a screenshot or a static image. It’s a real interactive HTML page with hover-over values, legends, and proper visualizations.

The Architecture That Matters

Three design decisions separate Anton from the ChatGPT-with-a-database pattern:

1. Credential Vault

This is the one that matters most for enterprise use. When you connect Anton to your PostgreSQL database or Salesforce instance, your credentials go into a local vault. The LLM only sees credential names — never the actual passwords or API keys. When Anton needs to query your database, it retrieves the secret at runtime without exposing it in the conversation context.

Use /connect to add data sources:

/connect

(anton) Choose a data source:
 0. Custom datasource (connect anything via API, SQL, or MCP)
 1. Amazon Redshift
 2. Databricks
 3. Google BigQuery
 4. HubSpot
 5. MariaDB
 6. Microsoft SQL Server
 7. MySQL
 8. Oracle Database
 9. PostgreSQL
 10. Salesforce
 11. Shopify
 12. Snowflake

2. Isolated Code Execution

Anton runs its analysis code in a sandboxed environment — a reproducible “show your work” scratchpad. You can ask it to dump the scratchpad and get a full notebook-style breakdown: every cell of code it ran, the outputs, and any errors. This means you can audit its reasoning, not just trust the output.

3. Multi-Layer Memory

Anton maintains three memory layers:

  • Session memory — what you’ve discussed in the current conversation
  • Semantic memory — learned patterns and domain knowledge
  • Long-term business knowledge — facts about your data sources, schemas, and preferences that persist across sessions

This means Anton gets better the more you use it. It remembers that your sales table uses created_at not date, that Q4 numbers need the holiday adjustment, and that your CEO prefers bar charts over line graphs.

Install

macOS desktop app:

# Download the signed .pkg
https://mindsdb-anton.s3.us-east-2.amazonaws.com/anton-latest-universal-signed.pkg

macOS/Linux CLI:

curl -sSf https://raw.githubusercontent.com/mindsdb/anton/main/install.sh | sh
export PATH="$HOME/.local/bin:$PATH"
anton

Windows (PowerShell):

irm https://raw.githubusercontent.com/mindsdb/anton/main/install.ps1 | iex

Where Anton Fits vs. Traditional BI

AntonTableau/Power BIMetabaseChatGPT + Code Interpreter
InputPlain EnglishDrag-and-dropSQL + GUIPlain English
OutputInteractive dashboards + insightsPersistent dashboardsPersistent dashboardsTables + static charts
Data sources12+ native + custom via API/MCPHundredsDatabasesUpload only
Credential securityVault (hidden from LLM)Native authNative authExposed in conversation
MemorySession + semantic + long-termN/AN/ASession only
Code auditFull scratchpad exportVisual lineageSQL visibleCode visible
Self-hosted✅ Local-first❌ Cloud/server❌ Cloud only
LicenseAGPL-3.0ProprietaryAGPL-3.0Proprietary
Best forExploratory analysis, quick dashboardsProduction dashboardsTeam SQL accessOne-off questions

The honest take: Anton excels at ad-hoc analysis — the “I need to understand this right now” moments. It’s not replacing your Tableau dashboards that refresh every morning for the executive team. It’s replacing the 45 minutes you spend writing SQL, pasting into a Jupyter notebook, making a chart, and sending it on Slack.

What MindsDB Brings to This

This isn’t MindsDB’s first rodeo. They built the MCP database integration layer that we covered previously — the federated query engine that connects 200+ data sources. Anton is the natural evolution: take that connectivity layer and put an autonomous agent on top of it.

The AGPL-3.0 license means you can run it internally, but if you modify and distribute it, you need to share your changes. For most use cases (running it on your laptop or internal server), this is fine.

Getting Started

  1. Install Anton (one command above)
  2. Run anton in your terminal
  3. Start with public data — ask about stock prices, weather, anything
  4. When ready, use /connect to add your databases
  5. Ask it to explain its work — show me your scratchpad

The repo is at mindsdb/anton — 314 stars in 3 days, growing fast.