Dashboard
Pinned Widgets
No widgets pinned. Use Manage Dashboard to pin widgets here.
Database Connections
No connections yet. Add your first database connection!
Data Sources
No data sources yet. Upload a CSV or JSON file to get started.
Relationships
Define join keys between data sources to enable cross-source widgets.
No relationships defined yet.
All Widgets
Pin widgets to your dashboard to load live data. Widgets listed here show metadata only.
No widgets yet. Create one to get started!
Settings
Profile
Change Password
Email Verification
Two-Factor Authentication
Use an authenticator app (Google Authenticator, Authy, Bitwarden, etc.) for time-based one-time passwords.
API Keys
API keys are long-lived credentials for integrating DataQueri with external applications, scripts, or dashboards. Unlike your session token (which expires after 60 minutes), API keys never expire — revoke them to disable access.
Use the key in the Authorization: Bearer dq_... header with any DataQueri API endpoint.
Quick Start
Fetch widget data from the command line using an API key:
curl -H "Authorization: Bearer dq_your_api_key_here" \
${API_URL || 'https://app.dataqueri.com'}/widgets/WIDGET_ID/data
Organization
You don't belong to any organization yet. Create one to start collaborating with your team.
Admin Panel
Users
Getting Started
Learn how to turn your data into live dashboards using plain English.
Welcome to DataQueri
DataQueri turns plain English into live data widgets. Just describe what you want to see — "show me monthly revenue by region" or "top 10 customers by total spend" — and DataQueri writes the query for you, runs it against your data, and displays the results as a table, chart, or metric card.
No SQL knowledge required. Your data stays in your database — DataQueri reads it, never writes to it.
Quick Start (3 minutes)
- Connect your data — Go to Data → Connections and add your database, or upload a CSV/JSON file under Data → Data Sources
- Create a widget — Click + Create Widget, pick your data source, and describe what you want in plain English
- Pin to your dashboard — On the Widgets page, click Pin to Dashboard on any widget to see it live
That's it. You can create as many widgets as you need and rearrange your dashboard at any time.
Connecting Your Data
DataQueri connects to your existing databases. We never move or copy your data — queries run directly against your database in real time.
| Source | How to connect |
|---|---|
| MongoDB | Enter your connection URI, database name, and optional auth database. |
| PostgreSQL | Enter host, port, username, password, and database name. |
| MySQL | Enter host, port, username, password, and database name. |
| SQL Server | Enter host, port, credentials, and optional instance name. |
| Oracle | Enter host, port, credentials, and service name. |
| CSV / JSON files | Upload directly — files are encrypted and stored securely. Max 10 MB per file. |
All connection credentials are encrypted with AES-256 before being stored. Use Test Connection to verify everything works before saving.
Writing Good Descriptions
The better your description, the better the generated query. Be specific about what you want to see, how you want it grouped, and which fields to include.
Examples that work well
- Show total sales amount grouped by country, sorted highest first
- Average order value per customer per month for the last 12 months
- Count of new users registered each week this year
- Top 10 products by revenue, showing product name, category, and total
- List all customers in London, showing name, email, and signup date
Tips
- Use Output Fields to explicitly list the columns you want (e.g.
customer_id, name, city, total) - Mention sorting: "sorted by date descending" or "highest first"
- Mention limits: "top 20" or "last 30 days"
- If the result isn't right, click Edit → Regenerate Query with a refined description
Your Dashboard
The Widgets page is your catalogue — it lists all your widgets without loading live data. To see live data, pin widgets to your Dashboard using the Pin to Dashboard button on each widget card.
Only pinned widgets run queries when you open the Dashboard, so you control exactly what loads and when. Use Manage Dashboard to quickly add or remove widgets.
Downloading Data
Every widget has CSV and JSON download buttons — on both the Dashboard and the Widgets catalogue. Click either button to fetch the latest data and save it as a file. Downloads include all rows returned by the query.
For automated or larger exports, use the API endpoint directly — the API returns the full result set without the 1,000-row display cap used in the dashboard view.
Joining Multiple Sources
You can combine data from different sources in a single widget — for example, join a CSV of customer segments with your orders database.
- Upload your file under Data → Data Sources
- Define the join key under Data → Relationships (e.g.
customers.customer_id = orders.cust_id) - Create a widget using Cross-Source mode and describe what you want
Joins happen locally in memory — the relevant data is fetched from each source, joined, and returned to you. No data leaves your infrastructure.
API Access
Every widget has a REST endpoint you can call from your own applications, scripts, or dashboards:
GET /widgets/{widget-id}/data
Authorization: Bearer dq_your_api_key_here
API keys are the recommended way to authenticate external integrations. They never expire and can be revoked at any time. Generate one in Settings → API Keys.
Your browser session uses a short-lived JWT (60 minutes) that auto-refreshes. For scripts, dashboards, or any external tool — always use an API key instead.
Security & Privacy
Your data security is our priority. Here's how we protect your information:
| Passwords | Hashed with bcrypt. Never stored in plain text. Cannot be recovered — only reset. |
| Connection credentials | Encrypted with AES-256 at rest. Only decrypted in memory at query time. |
| Uploaded files | Encrypted at rest. Original files are not retained after processing. |
| Read-only access | DataQueri never writes to your database. Write operations are blocked at the API level. |
| Data isolation | Every query is scoped to your account. Users cannot access each other's data, connections, or widgets. |
| API keys | Stored as SHA-256 hashes. The full key is shown once at creation. Revoke any time in Settings. |
| Two-factor auth | TOTP-based 2FA via authenticator apps. Enable in Settings. |
| No data sharing | Query results go directly to your browser. We do not store, log, or share your query results. |
Coming Soon
| Scheduled reports | Automatically run widgets on a schedule and receive results via email. |
| Embeddable widgets | Embed live widgets in external websites and internal tools via iframe or JS snippet. |
| Password reset via email | Self-service password reset using a secure email link. |
| Team workspaces | Share widgets and connections with team members. |
| Alerting | Set thresholds on widget data and get notified when values change. |
| Query history & audit log | Full history of who ran what, when, with execution details. |
Frequently Asked Questions
Can DataQueri modify my database?
No. All queries are read-only. Write operations are blocked before they reach your database.
Where does my data go?
DataQueri connects directly to your database, runs the query, and returns results to your browser. Query results are not stored or logged.
How does the AI work?
When you create a widget, your description and database schema (table names and column names) are sent to an AI model which generates the query. No actual data rows are ever sent to the AI.
What if the generated query is wrong?
Edit the widget, refine your description, and click Regenerate Query. Being more specific about fields, sorting, and grouping usually fixes it on the second attempt.
Is there a limit on how much data I can query?
The dashboard displays up to 1,000 rows to keep things fast. For aggregations (totals, averages, counts), all rows are processed but only the aggregated result is returned. The CSV/JSON download buttons and the REST API return the full result set without this display cap.
How do I integrate DataQueri with my own tools?
Generate an API key in Settings → API Keys. Use it in the Authorization: Bearer dq_... header with any widget's REST endpoint. API keys never expire — revoke them in Settings when no longer needed.
Can I use DataQueri on my phone?
Yes. DataQueri is fully responsive — the sidebar becomes a slide-out menu on smaller screens, and all pages adapt to your screen size. You can create, view, and manage widgets from any device.