Your data stays where it is
WONS BI never imports or replicates a table. When someone opens a question, it asks your database for just that result through a small bridge on the same machine, and the bridge can only read.
Ask your database. Anyone can read the answer.
Connect SQLite or PostgreSQL, build a question with a live preview, and put it on a dashboard anyone can filter. Your data stays where it is.
New accounts are added by an administrator.
Read-only, in place
Every question runs on your own database through a bridge that can only SELECT. Nothing is imported.
- Database
- Bridge
- WONS BI
Illustrative exampleModelled on the app’s sample sales database: 400 orders, 60 customers. Not real customer data.
Everything between a table and a shared answer.
WONS BI is one self-contained app. It reads the SQLite and PostgreSQL databases you already run and turns them into questions, charts and dashboards your whole team can use.
Made for people who do not write SQL
The likely choices are filled in and the preview updates as you go, so you review a question instead of building it from nothing.
Runs fully offline
One program, with its own database, accounts and pages. Nothing loads from another site, and nothing needs the internet but the mail you choose to send.
Alerts and email subscriptions
Get an email when a number crosses a line, or have a dashboard sent daily, weekly or monthly.
Names your team recognises
Give tables and fields display names and descriptions, and hide the ones nobody should pick.
Take the result with you
Download any result as CSV, Excel or JSON.
Build a question in seconds.
Pick a table, choose a measure, and watch the chart update as you go. The likely choices are already in place, so you review instead of starting from a blank form.
- Count, sum, average, min and max
- Up to 8 filters
- Bar, line, donut, table and more
- Read-only SQL when you need it
From a table to a shared dashboard.
Look before you ask.
See every table in a connected source with its column types, and page through the rows before you decide what to ask.
- Column types beside every name
- Display names and descriptions from your data model
- Hidden fields stay out of the builder
Ask with a live preview.
Choose a measure, group and filter. Bar, line, donut or table, sorted and limited the way you want, updating as you type.
- Join up to four tables
- Save a metric once and reuse it
- Write read-only SQL when the builder is not enough
Let the numbers come to you.
Get an email when a number crosses a line, or have a dashboard or question sent on a schedule.
- An alert fires once, then stays quiet for a cooldown you set
- Subscriptions go out daily, weekly or monthly
- Mail goes through the mail settings you configure
Three steps from database to dashboard.
Connect a database
An administrator runs the small bridge beside the app, saves its token once and presses Test connection. After that your tables are read in place, read-only.
Ask a question
Pick a table, choose a measure, group and filter. The preview updates as you go, and the defaults are already filled in.
Share the answer
Save it, put it on a dashboard, and anyone with an account can filter it and export the result.
Who can do what.
Everyone with an account can read the connected tables unless an administrator limits one to groups, so sign-up stays closed until an administrator opens it. What people can change, and which folders they can open, is narrower.
What each role can do
| What they can do | Members | AdministratorsAdmins |
|---|---|---|
| Browse the tables they may read | Yes | Yes |
| Ask and save questions, build dashboards | Yes | Yes |
| Filter dashboards and export results | Yes | Yes |
| Edit or delete their own questions and dashboards | Yes | Yes |
| Edit what someone else made | No | Yes |
| Connect the data bridge and test it | No | Yes |
| Open or close sign-up, add people and groups | No | Yes |
| Name, describe and hide tables and fields | No | Yes |
Folders can be limited to groups
Keep questions and dashboards in folders. A folder can follow the one it sits in, be open to everyone, or be limited to groups that can view or edit it. Someone without access sees a locked card, not the data.
Hiding a field in the data model tidies the builder. It is not a permission: limit a source or a table to groups under Data permissions, and keep anything more sensitive out of the connected database account.
Pricing that fits your team.
There is no price list to compare. Tell WONS who will use it and which databases you connect, and you get a quote back.
Contact for pricing
Write to hello@wons.bt and say three things. A reply with a quote follows.
- How many people will use it
- Which databases you connect: SQLite or PostgreSQL
- What you want to see first
Email WONS for pricing
Opens an email with those three lines ready to fill in.
In every copy
- Your own copy of the app, on your own server
- SQLite and PostgreSQL, read in place and read-only
- Questions, dashboards, alerts and email subscriptions
- Your name, logo and colours
- Sign-in, groups and who can see which folder
Questions, answered.
Plain answers about what WONS BI does with your data and what it does not do yet.
Does WONS BI copy my data?
No. Nothing is imported or replicated. When someone opens a question or a dashboard, WONS BI asks your database for that result and shows it. The app keeps its own accounts, saved questions, dashboards and settings. Two optional features keep a little more: an administrator can cache a question’s result for a few minutes, and can scan a column’s values so filters can offer a dropdown.
Which databases can I connect?
SQLite and PostgreSQL. Those are the two the bridge supports today.
Is the connection really read-only?
The bridge runs read-only transactions and accepts only SELECT queries. The connection guide gives you a script that creates a database account with SELECT access only, and a Test connection button that checks it. Your browser never sees the token or the connection strings.
Do I need to know SQL?
No. The visual builder covers tables, joins, groups, measures and filters, with a live preview. If someone on your team does write SQL, the read-only SQL editor is there, and an administrator can switch it off.
Who can see what?
Everyone with an account can read the connected tables unless an administrator limits one to groups under Data permissions, and questions and dashboards are readable by every signed-in person. Only an item’s owner (or an administrator) changes it. Folders can be limited to groups, and administrators manage groups and folder access. Sign-up is closed until an administrator opens it.
Can I embed a dashboard in my own app?
Yes. An administrator switches on signed embedding, lists the sites that may show it, and your product then shows a question or a dashboard in a frame through a signed link that expires. A public link, which can be turned off again, and a schedule by email are the other ways to share it with people who have no account.
How much does it cost?
There is no price list. The price depends on your team, so write to hello@wons.bt with how many people will use it and which databases you connect, and WONS replies with a quote.
Can it carry my own name and logo?
Yes. The name, the logo and the favicon are one record in the app’s own database, so a copy made for your company shows your brand, can have its public landing page switched off, and keeps only a small “Powered by WONS” line in the sidebar.
Does it work offline?
The app does. It is one self-contained program, and nothing on its pages loads from another site. It does need to reach your database, and alerts and subscriptions need the mail settings you configure.
Ask your first question.
Sign in, pick a table and watch the preview. The defaults do most of the work.