Insight
Data Foundations Setup
A small cloud data warehouse in BigQuery or Postgres with up to 4 business tools synced daily, 10 cleaned reporting tables and…
Insight
AI SQL Assistant
Type a question in plain language and get back the SQL query, ready to run or adapt.
Analysts spend too long writing routine SQL, and everyone else waits for them. This assistant turns a plain-language question into a query written against your own schema, runs it read-only and returns the results with the exact SQL shown. Analysts can check, adapt and reuse it. Every query comes with a plain-language explanation, so the logic is never hidden.
- Plain-language questions turned into SQL against your schema
- The exact query is always shown, ready to check or adapt
- Read-only connections, so data is never changed
$5,500
20–30 working days
Optional maintenance $275/mo
What it is
AI SQL Assistant turns a plain-language question into a SQL query written against your own schema, runs it read-only, and returns the results with the exact query shown so an analyst can verify or adapt it. Each query comes with a plain-language explanation.
Why businesses buy it
Routine queries eat analyst time that should go on harder problems, and small mistakes in joins or filters can quietly mislead a decision. This assistant writes a solid first draft against your real schema and explains it, so analysts move faster and less experienced staff learn as they go. Because every query is shown, nothing is a black box. The written scope sets the databases, metrics and testing against your history before you order.
Problems this solves
Non-technical staff depend on analysts for every database question
The assistant turns a plain-language question into a SQL query written against your own schema. It runs the query read-only and returns the results with a plain-language explanation.
Analysts rewrite similar queries from scratch again and again
Each answer shows the exact query used, so an analyst can verify it, adapt it or reuse it. Up to twenty-five recurring questions are defined so common queries are consistent.
Nobody trusts AI-written queries they cannot inspect
Every result comes with the SQL shown in full. Before launch, results are checked against three months of your historical data, and connections are read-only.
A good fit if
Your analysts already write SQL, but spend time on boilerplate joins and remembering table and column names.
You want every answer to show the exact query used, so it can be checked, reused or adapted by hand.
You already keep data in a queryable system such as PostgreSQL, MySQL, Snowflake or BigQuery, and can grant read-only access.
You want a faster first draft of a query, not a finished dashboard or a scheduled report.
Not the right fit if
Your audience is managers who do not want to see SQL at all, only an answer. See AI Data Analyst Agent, which answers in plain language with a chart.
You want a permanent dashboard rather than one query at a time. See AI Business Intelligence Dashboard, which builds a full dashboard.
You need the tool to explain an existing BI dashboard rather than write new queries. See AI BI Assistant.
You want automatic alerts when a metric crosses a threshold. See AI KPI Monitor, which watches defined KPIs continuously.
How it works
- An analyst asks a question in plain language, such as 'show monthly active users by plan tier for the last two quarters'.
- The assistant reads your schema, including table and column names and the relationships between them, and drafts a SQL query.
- The query runs read-only against your database, and both the query text and the result set are returned together.
- The analyst can copy the query, edit it, or ask a follow-up question to refine it further.
- Queries are checked against 3 months of your historical data during testing, so joins and filters match your real schema.
- Common questions can be saved as reusable templates, so the same query does not need to be rewritten each time.
What you provide within 72 hours
Your portal lists these the moment you order. Delivery starts the working day after everything is in and your access is checked.
- Read-only access to each database you want queried, such as PostgreSQL, MySQL, Snowflake or BigQuery.
- Your schema documentation, or access for us to read table and column structures directly.
- Your own definitions of the key metrics, so generated queries match how your team defines them.
- At least 3 months of historical data, so queries can be checked before launch.
- The priority questions your analysts ask most often, to prioritize the first templates.
- Admin access and API keys for every connected system, shared by adding our team as a user or creating a key you control, never by email.
- One decision-maker who can confirm the metric definitions and sign off on launch.
- An API key for your own AI model account (for example OpenAI or Google Gemini), created for this build with a spending limit.
The 72-hour rule. Send everything on your checklist, including access, within 72 hours of ordering so your build starts on time.
Timeline
Start
Intake confirmed and priority questions and metric definitions agreed.
Weeks 1–2
Schema read, database connections built, and query generation configured.
Week 3
Reusable query templates and alert thresholds set up.
Weeks 3–4
Queries tested against 3 months of your historical data.
Week 4
Your review and two rounds of changes.
Go-live
Live, handover report sent, 30 days of support starts.
| Option | Delivery time | Price |
|---|---|---|
| Standard | 20–30 working days | $5,500 |
| Express | 15–25 working days | $6,450 |
| Rush | 10–20 working days | $7,450 |
What you receive at handover
- The AI SQL assistant, live in email, Slack or a web dashboard
- Read-only connections to up to three data sources, with your schema configured
- Up to twenty-five defined metrics or recurring questions, one dashboard or report and up to five alerts
- A test report checking results against three months of your historical data
- An admin guide and the written handover report
- 30 days of post-launch support
Expected benefits and how to measure them
- Can let more people answer their own data questions
- Helps analysts start from a working query instead of a blank screen
- Keeps every answer checkable
- Query requests to analysts
- Count data requests in the analyst queue each month, before and after launch.
- Time to first answer
- Compare request-to-answer time for a sample of questions before launch with the assistant's turnaround.
- Queries corrected by analysts
- Ask analysts to log any generated query they had to fix each week.
Before you start: Log a few weeks of data requests with who asked and how long each took. Note which tables people ask about most.
These are things to track, not promised results. Outcomes depend on your data, your team and your market.
Running costs
The build itself is a one-time payment, shown before you buy. Running the assistant costs roughly $20 to $150 a month in your own accounts, covering AI model usage and hosting or scheduler fees, depending on how many queries analysts run.
AI usage during the build and testing is billed to your own accounts as well, so the database and AI provider relationships stay in your name.
Ask about running costsCustom requirements
If you need more than 3 databases connected, or query templates in a second language, add a note at checkout for a written Change Quote. Your order still runs on its original delivery date. Larger or bespoke projects go through the Custom AI request form instead.
Request a custom versionKeep it running
Monthly maintenance covers monitoring, fixes and change hours for new query templates, schema updates or added metrics. The change hours scale with the build. It starts after the included support period and can be cancelled any month.
$275/mo (5% of the build price a month, includes 2 change hours)
Optional. Starts after the post-launch support period. Cancel any month.
How maintenance worksHow this compares
| Do it yourself with a SaaS tool | Hire a custom agency | Upmark Labs | |
|---|---|---|---|
| Price | A text-to-SQL tool charges a monthly seat fee per analyst | A data agency quotes per query or per project | Ours is one fixed price, shown before you buy |
| Delivery | A text-to-SQL tool is instant to sign up but slow to learn your schema | An agency build usually takes several weeks | Ours has a fixed delivery time shown before you buy, with faster options |
| Query visibility | Some text-to-SQL tools hide the generated query behind a chat answer | An agency hands over queries at project end | Ours always shows the exact SQL alongside the result |
| Scope | A text-to-SQL tool license covers unlimited databases but unlimited setup too | An agency agrees scope during discovery | Ours is written on the Scope Card before purchase |
Questions about this product
What does the AI SQL Assistant price include?
One fixed price, agreed before work starts, covers up to three read-only database connections, up to 25 defined metrics, one delivery channel and query checks against three months of your history. Faster delivery options are shown in the price panel before you order, and there are no other build fees.
Which databases does the AI SQL Assistant support?
PostgreSQL, MySQL, Snowflake and BigQuery are the most common, alongside Google Sheets where a team keeps working data there instead. Tell us your setup during intake, and we confirm compatibility and read the schema in the first ten working days of the build.
How long does the AI SQL Assistant take to launch?
The standard, Express and Rush delivery times are all shown in the price panel before you order, and the clock starts once your intake is complete. Delays only happen when schema access or metric definitions arrive late, which moves delivery by three working days per day of delay.
Does the AI SQL Assistant show the query it writes?
Yes, always. Every result comes with the exact SQL query shown alongside it, so an analyst can check it, copy it, or edit it directly. Nothing runs without the query being visible, which is how the assistant stays auditable inside a technical team.
How much does the AI SQL Assistant cost to run each month?
Roughly $20 to $150 a month in your own accounts, covering AI model usage and hosting or scheduler fees. The figure depends on how many queries your analysts run and how many databases stay connected. You pay these providers directly.
Can I connect more databases to the AI SQL Assistant later?
Yes. A fourth or fifth database is priced in a written Change Quote before any work on it starts. Small changes, such as a new query template against an existing database, fit inside the monthly change hours that come with maintenance instead.
Who owns the queries the AI SQL Assistant generates?
You do. Every query and template belongs to you and runs against your own database, in your own accounts. If maintenance lapses, the assistant keeps generating queries; you lose the monthly monitoring and included change hours, not the build. While active, those hours cover new query templates, schema updates or added metrics.
Give your analysts a faster first draft, not more dashboards.
Order the AI SQL Assistant and your analysts get plain-language queries against your schema. The scope above is what you get, in writing, before you pay.
Works well with
Insight
Business KPI Dashboard Build
One business dashboard in Looker Studio or Power BI with up to 3 pages, 20 KPIs and 3 data sources, refreshed on…
Insight
AI Data Analyst Agent for Hotels & Hospitality
Answers plain-language questions against your data and produces charts and summaries, adapted for Hotels & Hospitality businesses that need quick answers on…