Meet Pallas.

DataPallas

The platform for mastering everything data — and never look back.

AI-powered data exploration. Semantic layer for consistent metrics. Pixel-perfect report generation. Automated report bursting. BI dashboards & analytics powered by OLAP engines. Self-service document portals.

All in one platform. Self-hosted. Open-source.

Connect to any data source. Define your metrics once in a semantic layer. Safely explore your data through natural conversation. Generate pixel-perfect reports. Automate delivery at scale. Embed charts, pivot tables, and dashboards directly into your own applications.

No glue code. No switching tools. No SaaS lock-in.

Features

Powerful Data Features

Your BI stack is 3 different tools stitched together.
It doesn't have to be.

  • 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 onto a drag-and-drop canvas, configure widgets visually, refine with shared filters
  • Built-in Chat2DB web app for conversational data exploration — ask questions in natural language and get SQL queries, charts, and dashboards

Replaces: Google Looker, SQL Server Management Studio, Toad, manual SQL queries

  • Design pixel-perfect PDF, Excel, HTML, and Word documents from any data source
  • Multi-format input from SQL, Excel, XML, CSV data sources
  • Large-scale report generation — seed thousands or millions of records and benchmark on your hardware

Replaces: Crystal Reports, SSRS, JasperReports

  • Split, route, burst, personalize, and auto-deliver reports to the right people
  • Distribute via email, FTP, cloud storage or document web portals — at scale, on schedule
  • Built-in quality assurance guarantees every delivery
  • Workflow automation for payslips, invoicing, payment processing

Replaces: report bursting, custom distribution tools / scripts, manual processes

  • 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 performance, financial reporting, and real-time business monitoring
  • Embed datatables, charts, and pivot tables as data-driven web components in your existing web apps
  • Build a data warehouse with OLTP-to-OLAP sync via CDC — powered by DuckDB, ClickHouse, and dbt

Replaces: Tableau, Metabase, Cube.dev

  • Build your own secure self-service portal for employees, customers, partners
  • Easily implement custom document portals for HR, billing, payments, and education
  • Choose between Grails or modern Next.js 15/React/Tailwind stacks

Replaces: adhoc web portals, SharePoint document libraries

  • Your council of AI oracles: Athena (data & reports), Hephaestus (automation & ETL), Hermes (portals), Apollo (modern web)
  • Domain experts that learn your projects, preferences, and workflows — improving with every interaction
  • Chat with your experts through the built-in Chat2DB web app or classic desktop and mobile chat apps
  • The intelligence layer that assists across the entire platform

Unique to DataPallas — no equivalent in competing tools

Demo

Product Presentation

DataPallas
Sales DashboardWholesale distribution — revenue, customers & product performanceQ1 2024 — GermanyREVENUE$147,820ORDERS312AVG ORDER VALUE$474CUSTOMERS68Revenue Trend20K15K10K5K0JanFebMarAprMayJunJulAugSepOctNovDecMonthRevenue by CategoryTOTAL$147.8KBeverages28%Dairy22%Confections18%Seafood14%Produce10%Grains8%
Connect. Understand. Query.Any database. AI-grouped schemas. SQL on demand.01CONNECTto any databasePostgreSQLMySQLOracleSQL ServerMariaDBIBM Db2SQLiteDuckDBClickHouseSupabase… and moreOne-click schema fetch ›02UNDERSTANDschema by business domainCubesSemantic LayerSales & Fulfillment› Orders› Order Details› ShippersCustomer Management› Customers› ContactsHuman Resources› Employees✦ AI-grouped automatically03QUERYvisual ER + AI-generated SQLCustomeridnameemailOrderidcustomer_idtotalProductidnamepriceHey AI, Help Me With This SQL Query …Visualize → Ask → Get SQL
Live Data WarehouseDuckDB · ClickHouse · dbt — OLTP-to-OLAP sync via CDCDuckDBEmbedded OLAP — zero admin100K – 100M rows · single fileClickHouseDedicated columnar warehouse100M – 10B+ rows · real-time CDCdbtStar-schema transformsraw OLTP → facts & dimensionsSUM OF NET_REVENUE · YEAR_QUARTER × CUSTOMER_COUNTRY⚡ near real-time CDC synccustomer_country2023-Q12023-Q22023-Q32023-Q4TOTALArgentina22,19634,77028,14536,369121,480Brazil33,93439,40339,55235,567148,456Canada38,08750,26946,21944,593179,168France54,38262,74282,35586,566286,045Germany62,94567,74272,47984,694287,860TOTAL211,544254,926268,750287,7891,023,009

Connect to Any Data Source

PostgreSQL, MySQL, SQL Server, Oracle, ClickHouse (billion-row OLAP) — and CSV, Excel, XML files.

Explore Data with AI (Safely)

Ask questions in plain English (Chat2DB) Get SQL, charts, and insights instantly.

Pixel-Perfect Reports

Generate PDF, Excel, HTML and Word reports — from any data source. AI-assisted design gets it right without much effort.

Automate Report Distribution

Email, FTP, cloud, or your own web portal — at scale, on schedule, with built-in quality assurance.

Workflow Automation

Payslips, invoicing, payments — automate document workflows end-to-end.

Self-Service Document Portal

Secure 24/7 access for employees, customers, and partners. Automate cash flow — get paid faster.

Embeddable Analytics & OLAP

Charts, pivot tables, and datatables — powered by your data warehouse. Drop them into any web app.

Meet the AI Crew

Athena, Hephaestus, Hermes, Apollo — domain experts that learn your projects and workflows.

AI Crew Where You Need It

Chat2DB web app, desktop, or mobile — your AI Crew is always within reach.

AI Is Fully Optional

Zero-AI policy? No problem. DataPallas delivers most of its value without any AI — every core feature works.

Your Data Stays Yours

Concerned about data security? Use AI-powered analysis while your data never reaches the AI.

Full features with zero exposure.
(Read our docs to learn how)

One Platform. Self-Hosted.

Data to delivery. No glue code. No SaaS lock-in. Open-source.

Portal

Secure Document
Distribution Portal

Automate your delivery workflow with a custom self-service portal. Whether it's payslips for staff or invoices for clients, users can securely access files and process payments instantly without manual intervention.

DataPallas
Burst. Deliver. Generate. DeliverThe pragmatic point of business data — docs in the right inboxesPDFExcel{alice@…}{john@…}{maria@…}huge Payslips.pdfor Invoices.xlsxor Statements.pdf… and any other docAliceor through a secure/login web portalJohnor through a secure/login web portalMariaor through a secure/login web portal… and thousands more
Distribute documents by email - use case 1Very effective and incredibly easy to configure — get it running in minutes with the email which everybody knows and love.mail.acme.com/inboxAComposeInbox1StarredSentDrafts3SpamTrashYour March 2024 payslipINBOXHRHR Department<[email protected]>to [email protected] — Apr 1, 2024, 09:14Hi Alice,Please find attached your payslip for March 2024.If you have any questions, just reply to this email.Kind regards,HR Team — ACME Ltd.1 ATTACHMENT · 128 KBPDFPayslip-March-2024.pdf128 KB · PDF documentSave
The self-service web portal - use case 2The heavy guns — every recipient logs in to securely access their own documents, anytime, anywhere.portal.acme.com/my-documentsADataPallasDashboardMy PayslipsProfileSettingsMy Payslips2024PDFPayslip — March 2024Mar 31, 2024ViewPDFPayslip — February 2024Feb 29, 2024ViewPDFPayslip — January 2024Jan 31, 2024ViewPDFPayslip — December 2023Dec 31, 2023ViewPDFPayslip — November 2023Nov 30, 2023View
Automate distribution & collect payments - use case 3The heavy guns — invoices, statements and bills delivered automatically with one-click pay built right in.INVOICEINV-2024-014DUEApril 14, 2024Issued: Mar 15, 2024FROMACME Ltd.12 Main Street, BerlinBILL TOJohn Doe[email protected]ITEMQTYUNITTOTALWidget A — PremiumQuarterly licence2$420.00$840.00Widget B — StandardAnnual subscription1$280.00$280.00Implementation ServiceOn-site, 2 hours1$130.00$130.00Subtotal$1,250.00Tax (0%)$0.00Grand Total$1,250.00Pay $1,250.00 NowStripe · PayPal · Bank transfer
Centralised adminOne pane of glass — every user, every document, at any scaleportal.acme.com/adminADMINDataPallasDashboardUsersDocumentsContent TypesReportsTOTAL USERS4,892+128 this monthDOCUMENTS THIS MONTH12,450+18% vs last monthACTIVE TODAY234LiveRecent DocumentsView all →DOCUMENTRECIPIENTTYPEDATESTATUSPDFPayslip — Mar 2024Alice JohnsonPayslip2 min agoDeliveredPDFINV-2024-014John DoeInvoice8 min agoViewedPDFStatement Q1 2024Maria SchmidtStatement12 min agoDeliveredPDFPayslip — Mar 2024Tom LeePayslip14 min agoDeliveredPDFINV-2024-013Sarah ParkInvoice21 min agoPaidPDFPayslip — Mar 2024Marco RossiPayslip28 min agoDelivered
Burst. Deliver. Generate. DeliverWhy delivery is at the core of the DataPallas architectureDelivery is the pointDashboards are visually pleasing and effective at conveyinginformation — and we made building them dead simple.But they are not why DataPallas exists.Document workflows are the main goal of managing business data —generating, sending, and collecting documents and payments.When you start DataPallas, Burst Reports is the very first screen you see —literally in minutes, even before you configure a database connectionor any report layout, your first documents go out to your customers.Delivery Workflows and Automation are the foundationon which DataPallas’s architecture is built.
Open Source

No Limits

DataPallas is open source — start using it today with no artificial restrictions. Upgrade to a licensed plan for professional support, regular updates, and peace of mind for your business.

Join Our Newsletter