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 GitHubFree · MIT license · Go and Vue 3 · Self-hosted · What's new in 2.3.1
Works with
- PostgreSQL
- MySQL
- MariaDB
- SQL Server
- SQLite
- Redis
- MongoDB
- Cassandra
- Kafka
- Elasticsearch
- OpenSearch
- S3 buckets
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 devThe 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 ChangelogEvery 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.
| Kind | Engines | What you get |
|---|---|---|
| SQL | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite | SQL Studio, objects, ER diagram, schema diff, dashboards |
| Key-value | Redis, Memcache | Scan, read and write keys; Laravel queues on Redis |
| Documents and wide columns | MongoDB, Cassandra | Collections and documents, keyspaces and CQL |
| Streams | Kafka | Topics, partitions and consumer groups |
| Search | Elasticsearch, OpenSearch | Indices, ILM policies, templates and shard allocation |
| Object storage | Amazon S3, Google Cloud Storage, Alibaba OSS, Huawei OBS | Browse 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.
A block or the whole dashboard, as PDF, PNG, Excel, CSV, SQL or JSON.
Share and embedA read-only public link, or an iframe of the whole dashboard or a single block.
PresetsSave a filter and parameters as a named view, and open the dashboard on it by default.
Ask your dataAsk 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.
| Step | What happens |
|---|---|
| Request | The SQL, the connection and a short reason. Dry Run shows what it would do; Revise makes a new revision. |
| Review | Each step of the rule needs its approvals. A reviewer can Approve, Request Changes, or Reject, and a rejection always carries a reason. |
| Run | Once 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 credentialsConnection passwords and keys are encrypted at rest and never returned by the API.
Two-factor sign-inAuthenticator codes per user, which an administrator can require for everyone.
Roles and access groupsRoles decide what people may do; folder-based access groups decide which connections they see.
AuditedSign-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.
| Variable | Purpose |
|---|---|
JWT_SECRET | Signs sign-in tokens. Use a long random value (make secrets prints one). |
NIAS_ENCRYPTION_KEY | A 32-character key that encrypts stored database credentials. |
DEFAULT_ADMIN_USERNAME | The first admin, created only while there are no users yet. |
DEFAULT_ADMIN_PASSWORD | That admin's password. Production refuses to start with the placeholder. Change it after your first sign-in. |
DB_DRIVER | Where Nias keeps its own data: postgres (the default) or sqlite. |
DATABASE_URL | A PostgreSQL URL, or with sqlite the database file path (nias.db when unset). |
CORS_ORIGIN | The browser origins allowed to call the API. |
REDIS_URL | Optional cache and rate-limit store. Without it, Nias uses memory. |
AI_API_KEY, AI_BASE_URL, AI_MODEL | An 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