Home / Nias

From a SQL query to a dashboard your team trusts.

Nias is an open-source studio for the databases and services your team runs. Explore schemas, run and save SQL, turn results into dashboards, and send risky writes through review first. You host it; it's MIT licensed.

Run it with Docker Read the code on GitHub

Free · MIT license · Go and Vue 3 · Self-hosted · What's new in 2.3.1

Works with

Watch it, then look closer.

A dashboard, a query, the ER diagram, and a change rejected with a reason. Recorded from the real app on a made-up coffee shop database.

One studio instead of six tabs.

The SQL client, the BI tool, the change tickets and the audit spreadsheet, in one place your team signs in to.

Dashboards straight from your SQL.

Save a query, pick a chart, and it becomes a block on a dashboard. Filter it, export it to PDF, Excel or CSV, or share a read-only link and embed it anywhere.

Risky writes wait for a second pair of eyes.

An UPDATE or DELETE on a guarded connection becomes a request. A reviewer approves it, asks for changes, or rejects it with a reason, and only then can it run.

Every query leaves a trail.

Who ran what, on which connection, how long it took and how many rows it touched. The audit log keeps page views and query events side by side.

Saved queries
A shared SQL library, filtered by connection, that reopens straight in the editor.
More than SQL
Redis keys, MongoDB documents, Kafka topics, search indices and S3 buckets, each with its own screen.
Servers too
Docker, Nginx, Cron, files over SFTP and Kubernetes, reached over the SSH hosts you add.
Schedules and pipelines
Recurring queries and reports, a visual ETL canvas, backups and watchers.
Monitoring
Health, slow queries, logs, uptime with TLS expiry, and host and pod metrics.
Locked down
Roles, folder-based access groups, two-factor sign-in, and credentials encrypted at rest.

Run it on your own server.

With Docker

Nias and a PostgreSQL for its own data, from the repository's compose file.

shell
 git clone https://github.com/PandhuWibowo/anveesa-nias.git
cd anveesa-nias
# Fresh secrets, kept next to the compose file
make secrets > deploy/compose/.env
echo "POSTGRES_PASSWORD=$(openssl rand -hex 16)" >> deploy/compose/.env
docker compose -f deploy/compose/docker-compose.yml up -d
# Open http://localhost:8080 and sign in as admin,
# with the password in deploy/compose/.env

Or, for development

The Go API and the Vue studio, each with live reload.

# Paste the three values make secrets prints into .env cp .env.example .env && make secrets # The API on :8080 (Go 1.25+) make dev-server # In another terminal: the studio on :5173 (Node 20+) cd web && npm install && npm run dev

The first admin is created only while there are no users yet. Change its password, and turn on two-factor sign-in, right after you sign in.

Reference, for when you need the details.

On this page

Report an issue Changelog

Every screen

Besides Home, the sidebar has six places, with Settings at the bottom. Each opens on its most used screen, with the rest as tabs along the top. ⌘K jumps to any of them.

Database

SQL Studio
Browse tables and run SQL
Objects
Indexes, views, functions and triggers
ER diagram
Table relationships and a join path finder
Schema diff
Compare schemas across environments
Row history
Row-level change log
Sessions, logs, users
Live sessions, slow and error logs, database users and grants
Replication, parameters
PostgreSQL publications, subscriptions and pg_settings
Redis, MongoDB, Kafka and more
Keys, documents, topics, indices and buckets, per connection type

Analytics

Overview
Saved queries, dashboards and reports at a glance
Dashboards
Saved queries as chart blocks
Saved queries
A reusable SQL library
Ask your data
Plain-language questions turned into read-only SQL

Changes

Approvals
Review controlled SQL changes
Change sets
Plan and run database changes together
Data scripts
Preview programmable updates before they run
Script requests
Data script plans waiting for review
Approval rules
Who approves what, per connection

Automation

Schedules
Recurring queries and reports
Pipelines
A visual ETL canvas
Backups
Download, back up and restore
Watchers
Watch tables and queries for changes

Monitoring

Health
Connection and service health
Query performance
Slow queries and what they cost
Logs
Search and tail logs
Uptime
Heartbeats, latency and TLS expiry
Infra metrics
Host and pod metrics
Audit log
Access, actions and query events

Infrastructure

Servers
The SSH hosts Docker, Files, Nginx and Cron use
Docker
Containers, images and compose
Nginx
Configs, sites and access logs
Cron
The native crontab on each server
Files
Browse server files over SFTP, with sudo where needed
Kubernetes
Workloads, services and pod logs, per cluster

Settings

Connections
Database and service endpoints
Users, roles, access groups
Accounts, permission policy and folder-based connection access
Alert channels
Telegram, Discord, Slack and webhooks
AI provider
Your API key, base URL and model
Security
Password, 2FA and sessions

Connections

Add one under Settings → Connections. Credentials are encrypted with NIAS_ENCRYPTION_KEY and never sent back to the browser. A connection can go through an SSH tunnel.

KindEnginesWhat you get
SQLPostgreSQL, MySQL, MariaDB, SQL Server, SQLiteSQL Studio, objects, ER diagram, schema diff, dashboards
Key-valueRedis, MemcacheScan, read and write keys; Laravel queues on Redis
Documents and wide columnsMongoDB, CassandraCollections and documents, keyspaces and CQL
StreamsKafkaTopics, partitions and consumer groups
SearchElasticsearch, OpenSearchIndices, ILM policies, templates and shard allocation
Object storageAmazon S3, Google Cloud Storage, Alibaba OSS, Huawei OBSBrowse buckets and files

Dashboards

A dashboard is a set of blocks, and every block is a saved query drawn as one of nine views. Each block has its own filter, and the dashboard refreshes when it opens.

AI Analytics drafts SQL for you to review before it runs. Saved queries feed dashboard blocks, and a dashboard or a single block can be exported, published read-only, or embedded.
KPI Table Bar Horizontal bar Line Area Scatter Pie Donut Exports

A block or the whole dashboard, as PDF, PNG, Excel, CSV, SQL or JSON.

Share and embed

A read-only public link, or an iframe of the whole dashboard or a single block.

Presets

Save a filter and parameters as a named view, and open the dashboard on it by default.

Ask your data

Ask in plain words and get read-only SQL to review, with the AI provider you set.

Change management

Approval rules decide which connections need review and who gives it. A write on those connections becomes a request instead of running straight away.

StepWhat happens
RequestThe SQL, the connection and a short reason. Dry Run shows what it would do; Revise makes a new revision.
ReviewEach step of the rule needs its approvals. A reviewer can Approve, Request Changes, or Reject, and a rejection always carries a reason.
RunOnce every step approves, the request can be executed. The result, and who ran it, land in the audit log.

Change sets group related changes into one reviewed unit. Data scripts written in JavaScript, Python or PHP produce a plan you preview and send for review as a script request.

Security

Nias is a door to your production data, so it is built to be strict about who walks through.

Encrypted credentials

Connection passwords and keys are encrypted at rest and never returned by the API.

Two-factor sign-in

Authenticator codes per user, which an administrator can require for everyone.

Roles and access groups

Roles decide what people may do; folder-based access groups decide which connections they see.

Audited

Sign-ins, page views, queries and changes are logged, with alerts to Telegram, Discord, Slack or a webhook.

Configuration

Everything is an environment variable; start from .env.example and never commit real values. make secrets prints fresh ones.

VariablePurpose
JWT_SECRETSigns sign-in tokens. Use a long random value (make secrets prints one).
NIAS_ENCRYPTION_KEYA 32-character key that encrypts stored database credentials.
DEFAULT_ADMIN_USERNAMEThe first admin, created only while there are no users yet.
DEFAULT_ADMIN_PASSWORDThat admin's password. Production refuses to start with the placeholder. Change it after your first sign-in.
DB_DRIVERWhere Nias keeps its own data: postgres (the default) or sqlite.
DATABASE_URLA PostgreSQL URL, or with sqlite the database file path (nias.db when unset).
CORS_ORIGINThe browser origins allowed to call the API.
REDIS_URLOptional cache and rate-limit store. Without it, Nias uses memory.
AI_API_KEY, AI_BASE_URL, AI_MODELAn instance-wide provider for Ask your data. People can also set their own in Settings.

Before you open a pull request

 cd server && go test ./...
cd ../web && npm run build

常見問題

What is Anveesa Nias?

Nias is an open-source studio for SQL and dashboards that you host yourself. You explore schemas, run and save queries, turn results into dashboards, and send risky writes through review before they run. It is MIT licensed.

Which databases does Nias support?

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

How do I install Nias?

Clone github.com/PandhuWibowo/anveesa-nias, generate secrets with make secrets, and start it with Docker Compose. It opens on http://localhost:8080. The full steps are in the Run it with Docker section of this page.

Can I share or embed a Nias dashboard?

Yes. Share a read-only link, embed a whole dashboard or a single block in an iframe, or export it to PDF, PNG, Excel, CSV, SQL or JSON.

How does Nias stop a bad write from reaching production?

On a guarded connection, a write becomes an approval request. A reviewer approves it, sends it back for changes, or rejects it with a reason. Nias also keeps an audit log of who did what.

Can I try Nias without installing it?

Yes, there is a live demo at nias.anveesa.com.

Missing an engine, or a screen?

Nias is open source. Open an issue and tell us what your team needs.

Open an issue on GitHubBack to install steps