Anveesa Nias: from a SQL query to a dashboard your team trusts

Anveesa Nias is an open-source, self-hosted studio for SQL, ER diagrams, dashboards, reviewed database changes, audit, and the services your team runs. MIT licensed.

Overview

Explore schemas, run and save SQL, turn results into dashboards, and send risky writes through review first. Nias is a Go API and a Vue 3 studio you host yourself, with Docker Compose or for development.

Works with

PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Redis, Memcache, MongoDB, Cassandra, Kafka, Elasticsearch, OpenSearch, and S3-compatible buckets.

Dashboards

Every block is a saved query drawn as a KPI, table, bar, horizontal bar, line, area, scatter, pie, or donut. Export to PDF, PNG, Excel, CSV, SQL, or JSON, share a read-only link, or embed a dashboard or a single block.

Change management and security

Writes on guarded connections become approval requests that reviewers approve, send back for changes, or reject with a reason. Roles, access groups, two-factor sign-in, encrypted credentials, and an audit log are built in.