Dashboard Builder connects to 25+ data sources: SQL databases, Google Sheets, JSON APIs and files such as Excel, CSV and PDF. Pick your source below to see how to connect it and build your first dashboard. You can combine several sources on the same dashboard.
All data sources
| Source | How it connects | Guide |
|---|---|---|
| MySQL / MariaDB | Direct connection | MySQL dashboard |
| PostgreSQL | Direct connection | PostgreSQL dashboard |
| Microsoft SQL Server | Direct connection (PDO_SQLSRV) | Dashboard app |
| Oracle | Direct connection | Oracle dashboard |
| SQLite | Database file | Gallery examples |
| ODBC | Any ODBC driver | ODBC dashboard |
| Google Sheets | Publish to web → CSV link (live) | Google Sheets dashboard |
| JSON / REST API | URL or file | JSON dashboard |
| Excel | Upload .xlsx | AI Dashboard Generator |
| CSV | Upload or link | AI Dashboard Generator |
| Upload; tables are read from the PDF | AI Dashboard Generator |
Plus Sybase, Cubrid and other databases through their drivers or ODBC. The cloud edition connects to databases that are reachable from the internet; the self-hosted edition also reaches databases on your private network.
How to connect a data source
Open the data connection panel. In the dashboard designer, click the database icon.
Choose the source type. Pick the database, or choose a file (Excel, CSV, PDF), Google Sheets or JSON.
Enter the details. Server, database, user and password for a database; upload or paste a link for a file or sheet.
Check the connection. A green check means you are connected. A red cross usually means wrong credentials, a firewall rule or a missing PHP driver.
Query and chart. Use the SQL builder or write SQL, map the columns and pick a chart.
Mixing sources on one dashboard
Each chart has its own connection, so one dashboard can show orders from MySQL, targets from Google Sheets and supplier costs from a PDF invoice. For ideas, see the data visualization tool and BI dashboard guides.
Frequently asked questions
Build your first dashboard in minutes
Upload Excel, CSV or PDF to the free AI Dashboard Generator, or download the self-hosted free trial and connect your database.
Build with AI, free Download the free trial Start a 5-day cloud trial