One workspace for operational analytics
From source connection to datasets, queries, dashboards, exports, and notifications, Ogma keeps the analytics workflow in one self-hosted product.
Connect any source
Link your databases, files, and APIs in seconds. PostgreSQL, MySQL, SQLite, CSV, Parquet, JSON, all with automatic schema introspection.
Reusable datasets
Model source data into governed datasets backed by DuckDB materialization, then reuse them across queries, visualizations, and dashboards.
AI-assisted analysis
Generate SQL from plain language, document tables and columns, and configure organization-level AI providers for your workspace.
Rich visualizations
Create reusable charts, tables, and custom views from your datasets. Choose from bars, lines, areas, pies, scatter plots, and more.
Composable dashboards
Assemble visualizations into interactive dashboards. Flexible grid layout, resize and reorder, no code required.
Automation & alerts
Run pipelines manually or on a schedule, export dashboards to PDF or image, and send notifications through email, Slack, Discord, Teams, WhatsApp, or LINE.
Database connectors
Native drivers for PostgreSQL, MySQL, MariaDB, and SQLite. No JDBC, no middleware, just direct, fast connections.
File support
Upload or reference CSV, Parquet, and JSON files. Ogma parses schemas automatically.
SSH tunneling
Reach databases inside private networks via SSH jump hosts, with zero firewall changes required.
Schema introspection
Browse tables, columns, types, and row counts in the source explorer. Test connectivity before you save.
Reusable dataset layer
Turn source SQL into durable datasets that can feed multiple queries, visualizations, and dashboards without duplicating logic.
DuckDB materialization
Materialize database and file results into embedded DuckDB tables or views for fast repeated reads and source-independent analysis.
Dataset status tracking
Track READY and ERROR states, last refresh timestamps, and validation failures before downstream queries depend on a dataset.
Column configuration
Apply aliases and hidden-column settings to keep reusable data products understandable for the rest of the team.
Monaco SQL editor
Full-featured editor with syntax highlighting, autocomplete, and keyboard shortcuts. Same engine as VS Code.
AI text-to-SQL
Describe what you need. Ogma generates the SQL using LLM integration, then lets you review and edit before running.
Query folders
Organize analytics work into folders, restrict access to selected groups, and keep shared workspaces readable as usage grows.
AI auto-documentation
Generate table and column descriptions with your connected LLM so the catalog stays useful as schemas evolve.
Chart types
Bar, line, area, pie, metric, radar, radial, heatmap, pyramid, bullet, sankey, treemap, and table views.
Data tables
Sortable, filterable tables for detailed row-level data exploration.
Reusable components
Create a visualization once and reuse it across multiple dashboards.
Live refresh
Refresh visualizations on demand or through scheduled pipeline runs that keep dashboard data current.
Grid-based builder
Drag-and-drop composition. Resize panels, reorder blocks, adjust layouts without code.
Shared dashboards
Share individual dashboards with team members. Access controlled by workspace roles.
Multi-workspace
Isolate projects and teams in separate workspaces. Invite members with ADMIN or MEMBER roles.
PDF and image export
Render dashboards and individual queries into PDF, PNG, or JPEG outputs for reporting and distribution.
Cron scheduling
Set any cron expression to refresh pipelines automatically, whether hourly, daily, or on custom intervals.
Job history
Full execution log with status, duration, and error details for every pipeline run.
Action steps
Attach export steps to pipelines so scheduled work can produce dashboard snapshots automatically.
Notification steps
Send pipeline outputs or alerts through email, Slack, Discord, Teams, WhatsApp, or LINE.
Organizations and users
Create organizations, invite members, and separate work cleanly across teams and environments.
Groups and access
Use groups to control who can see restricted query folders and administrative surfaces.
Activity history
Review actions, statuses, failures, and audit context across exports, jobs, and administration.
License controls
Gate premium surfaces with license-aware controls while keeping the open-source core available.
MCP servers
Register SSE or stdio MCP servers at the organization level to extend workflows with external tools.
AI provider settings
Configure organization-level AI providers and review generation activity from the admin console.
Storage settings
Manage storage backends for files, exports, and generated assets from a central configuration surface.
Modular backend
Work across bounded contexts for connectivity, analytics, dashboards, automation, identity, and core services.