Skip to main content

Welcome to Actyze

Actyze is a fully open-source, AI-native analytics platform that lets anyone ask questions across live data and act on insights — without ETL, license keys, or vendor lock-in. Licensed under AGPL v3.

Why Actyze?

Most analytics tools either lack AI capabilities (Metabase, Superset) or lock AI features behind proprietary clouds (Snowflake Cortex, Databricks Genie). Actyze is different:

  • Fully open source under AGPL v3 — no feature gates, no license keys, no paywalls
  • NL-to-SQL with a semantic intelligence layer — FAISS-powered schema matching, community-driven
  • Voice AI assistant built in — talk to your data, hands-free
  • Federated querying via Trino — query any database (PostgreSQL, MySQL, Snowflake, MongoDB, and more) from a single interface
  • Self-host in 2 minutes with Docker Compose — your data never leaves your infrastructure
"Show me total revenue by region for Q4 2025"

SELECT region, SUM(revenue) as total_revenue
FROM sales
WHERE quarter = 'Q4' AND year = 2025
GROUP BY region

How Actyze Compares

CapabilityActyzeMetabaseSupersetSnowflake CortexDatabricks Genie
Open sourceAGPL v3AGPL v3Apache 2.0ProprietaryProprietary
NL-to-SQL50+ languagesNoNoEnglish onlyEnglish only
Voice AI assistantBuilt inNoNoNoNo
Federated queries (Trino)Any databaseLimitedLimitedSnowflake onlyDatabricks only
LLM flexibility100+ providersN/AN/ASnowflake LLMDatabricks LLM
Self-hostedDocker + K8sDocker + K8sDocker + K8sCloud onlyCloud only
Feature gates / license keysNoneNoneNonePer-credit pricingPer-credit pricing

Key Features

Natural Language to SQL

Powered by advanced language models, Actyze understands complex business questions and generates accurate SQL queries. Recommended: Claude Sonnet 4.5, GPT-4o, or equivalent models for optimal results. All features are free and unlimited.

Multilingual Support (50+ Languages)

Query your data in over 50 languages including English, Spanish, French, German, Chinese, Japanese, Arabic, Hindi, and more. Powered by advanced multilingual semantic embeddings for accurate schema matching across languages.

Voice AI Assistant

Ask questions by voice. Actyze's built-in voice assistant converts spoken questions into SQL queries and reads back results — ideal for hands-free analytics and accessibility.

Intelligent Schema Detection

FAISS-powered semantic search combined with spaCy Named Entity Recognition ensures the right tables and columns are selected for your queries. Community-powered and continuously improving.

Private & Secure

Deploy Actyze within your own infrastructure. Your data never leaves your network. Supports Kubernetes and Docker deployments.

Multi-Database Support via Trino

Connect to PostgreSQL, MySQL, Snowflake, MongoDB, Oracle, BigQuery, Redshift, and dozens more from a single interface via Trino federated queries.

100+ LLM Providers

Bring your own LLM — Actyze supports 100+ providers through LiteLLM, from OpenAI and Anthropic to self-hosted Ollama models. No vendor lock-in.

Fast & Scalable

  • Query generation in 1-3 seconds with external LLMs
  • Schema recommendations in under 100ms
  • Kubernetes-native with horizontal scaling

Architecture

Actyze consists of core components that work together to transform natural language into SQL queries:

┌─────────────────┐    ┌──────────────────┐    ┌─────────────────┐
│ Frontend │ │ Nexus API │ │ PostgreSQL │
│ (React+nginx) │───▶│ (FastAPI) │───▶│ (Metadata DB) │
└─────────────────┘ └──────────────────┘ └─────────────────┘


┌──────────────────┐
│ Schema Service │
│ (FAISS+spaCy) │
└──────────────────┘


┌──────────────────┐
│ Trino │
│ (Optional) │
└──────────────────┘


┌─────────────────────┼─────────────────────┬─────────────────────┐
│ │ │ │
▼ ▼ ▼ ▼
┌───────────────┐ ┌───────────────┐ ┌───────────────┐ ┌───────────────┐
│ │ │ │ │ │ │ │
│ PostgreSQL │ │ MySQL │ │ Snowflake │ │ MongoDB │
│ │ │ │ │ │ │ │
│ Your Data │ │ Your Data │ │ Your Data │ │ Your Data │
│ │ │ │ │ │ │ │
└───────────────┘ └───────────────┘ └───────────────┘ └───────────────┘

Components

  • Frontend: React-based web application with nginx, providing the user interface
  • Nexus API: FastAPI orchestration service that handles LLM integration and query management
  • PostgreSQL: Stores user data, query history, metadata, and uploaded files
  • Schema Service: FAISS vector search with spaCy NER for intelligent schema recommendations
  • Trino: Optional distributed SQL query engine that connects to multiple data sources (PostgreSQL, MySQL, Snowflake, MongoDB, and more)
  • Your Databases: Connect your existing databases through Trino connectors for unified querying

Deployment-Specific Details:

Get Running in 2 Minutes

git clone https://github.com/actyze/dashboard-docker.git
cd dashboard
cp docker/env.example docker/.env
# Add your LLM API key to docker/.env
./docker/start.sh

Access at http://localhost:3000 — no license key needed.

See: Docker Deployment Guide

Kubernetes (production)

helm install dashboard ./dashboard \
--namespace actyze \
--create-namespace \
--values dashboard/values.yaml \
--values dashboard/values-secrets.yaml

See: Helm Deployment Guide

LLM Provider Support

Actyze supports any LLM provider with flexible authentication:

ProviderBest ForResponse Time
Claude Sonnet 4.5Recommended - Superior accuracy2-5s
GPT-4oRecommended - Excellent accuracy3-6s
PerplexityFast inference2-4s
GroqUltra-fast inference<1s
Together AIOpen source models1-3s

Note: Any equivalent or higher-performance models will also provide excellent results.

See: LLM Provider Configuration

Quick Start

Get started with Actyze in three steps:

  1. Install Actyze - Choose Docker or Helm
  2. Configure LLM Provider - Set up your AI model
  3. Connect Your Data Sources - Configure Trino connectors for your databases

Use Cases

Business Intelligence

Enable business analysts to query data without SQL knowledge:

  • "What were our top 10 products by revenue last quarter?"
  • "Show customer churn rate by region"

Data Exploration

Let data scientists explore datasets faster:

  • "Find all tables containing customer information"
  • "Show me the schema for the sales database"

Operational Analytics

Empower operations teams with real-time insights:

  • "How many orders are pending shipment?"
  • "Show inventory levels below reorder point"

Support & Resources

Next Steps

Ready to get started? Follow our installation guide:

-> Installation Guide