Helps you reach "I get it" and then "it's live and beautiful" for any data requirement — faster than any other platform.
DataPallas is a full-stack BI platform — interactive dashboards and pivot tables (like Tableau or Power BI) alongside pixel-perfect report generation (like Crystal Reports), all in one tool. The video above covers building dashboards for an algorithmic trading platform, but DataPallas can be easily used across ERP, CRM, Finance, Accounting, or any other domain.
For a deep-dive into the algo trading dashboards shown above, read this blog post.
To explore the full range of what DataPallas can do — from PDF bursting to SQL-driven reports to live BI dashboards — read on.
| What you need | What you're using today | DataPallas |
|---|---|---|
| 1. Data Exploration | Chat2DB AI — ask in natural language, get SQL, results, and charts | |
| 2. Dashboards & Analytics | Embeddable data-tables, charts, pivot tables, and analytics | |
| 3. Report Generation | Pixel-perfect PDFs, Excel, HTML, Word from any data source |
Also includes: 4. report bursting | 5. self-service document portals | 6. AI crew
- Download datapallas-server-docker.zip
- Extract the zip and navigate to the
DataPallasdirectory - Run
docker compose up -d - Open
http://localhost:9090
1. AI-Powered Data Exploration
- Connect to any database — PostgreSQL, MySQL, SQL Server, Oracle, SQLite, DuckDB, ClickHouse, and more
- Build interactive views on the explore data canvas — drag tables or cubes, configure widgets visually, apply shared filters
- Built-in Chat2DB web app — ask questions in natural language, get SQL, results, and visualizations instantly
2. Dashboards, Analytics & Semantic Layer
- Define metrics, dimensions, and joins once in a semantic layer (cubes) — every chart, pivot, and dashboard reads from the same source of truth
- Build interactive dashboards for sales, finance, and real-time business monitoring
- Embed datatables, charts, and pivot tables as web components directly in your own apps
- Build a data warehouse with OLTP-to-OLAP sync via CDC — powered by DuckDB, ClickHouse, and dbt
- Your council of AI domain experts: Athena (data & reports), Hephaestus (automation & ETL), Hermes (portals), Apollo (modern web)
- Agents learn your projects, preferences, and workflows — improving with every interaction
- Chat through the built-in Chat2DB web app or classic desktop and mobile chat apps
4. Report Bursting & Automation
- Split, personalize, and auto-deliver reports to the right people — via email, FTP, or cloud storage, at scale, on schedule
- Built-in quality assurance guarantees every delivery
- Automate payslips, invoicing, and payment processing workflows
- Design pixel-perfect PDFs, Excel, HTML, and Word documents from any data source
- Multi-format input: SQL, Excel, XML, CSV
- Large-scale generation — seed millions of records and benchmark on your hardware
6. Self-Service Document Portals
- Build secure portals for employees, customers, and partners — HR, billing, payments, education
- Choose between Grails or modern Next.js 15/React/Tailwind stacks
See all samples — report bursting, report generation, interactive dashboards, pivot tables, and more.
Full documentation is available at datapallas.com/docs.
Before you build, DataPallas is the best possible platform for learning anything data — SQL, data modelling, ETL, data warehouses. 5 minutes on your laptop and BAM — Oracle, SQL Server, Postgres, all running with real data. DataPallas ships with sample real-world databases ready to query on day one, so you learn on actual schemas, not toy examples.
We welcome contributions! Bug reports, feature requests, documentation, or code — every bit helps.
- Bug reports & feature requests: Open an issue
Start using it today with no artificial restrictions — all features included. No community vs. enterprise editions.
Watch this repository to be notified of future updates: