SQL and NoSQL queries
Queries written, fixed or sped up so you get the right numbers from your database, quickly.
GradaxEuropean companyOrder outright
Founded 2014·Built and operated in Europe·1 day to 2 weeks
About this service
We write the queries that get the answers you need out of your database: reports, exports, data checks and views for dashboards. We also fix queries that return wrong numbers or take minutes to run. Each query comes with a plain explanation of what it does, so you can trust and reuse it.
Wrong numbers usually come from definitions
When two reports disagree, people assume one query has a bug. Often both queries are correct; they just answer slightly different questions. One counts orders by the date placed, the other by the date paid. One includes cancelled orders, the other does not. One counts a customer who bought twice as two customers. Each choice is reasonable, and together they produce numbers that do not match.
So before writing a query, we turn the business question into a precise definition and write it down. What counts as a sale, a customer, an active user, a month? Then we write the query, run it, and reconcile the result against a total you already trust, such as the figure in your accounting system. Differences are explained, not hidden.
Fast queries, readable queries
A slow query is usually doing more work than it needs to: scanning a whole table where an index would find the rows directly, joining before filtering, or calculating the same thing repeatedly. Rewriting it, sometimes with an index or a materialised view, can turn minutes into milliseconds. We show the timings before and after.
Speed is only half of it. A query nobody can read becomes a query nobody dares change. We write SQL with clear names, comments on the business logic and consistent formatting, and save frequently used queries as views so dashboards and reports can share one definition rather than each having its own copy.
What you get
Everything below is in the price. Nothing here is an upgrade.
- Written or fixed queries
- Query explanations and assumptions
- Saved views or stored functions where useful
- Timing results for optimised queries
What changes
- Queries that return the right numbers, checked against known totals
- Slow queries made faster, with before-and-after timings
- Saved views or functions your dashboards can read directly
- Every query explained in plain words, with its assumptions noted
How it runs
Clarify
The business question turned into a precise definition.
Write
The query written and run against your data.
Check
Results reconciled against totals you already trust.
Explain
Each query documented so others can reuse it.
Compare the sizes
The standard price for each size. Extras are priced beside it, not hidden behind a call.
| Included | Up to five queries€2901 to 3 working days | Reporting set€5001 week | Performance and reporting€1,0502 weeks |
|---|---|---|---|
| Up to five queries written or fixed | Included | Included | Included |
| Result checks | Included | Included | Included |
| Plain-language explanations | Included | Included | Included |
| One round of changes | Included | Included | Included |
| Saved views for dashboards | Not included | Included | Included |
| Query performance tuning | Not included | Included | Included |
| Index recommendations | Not included | Included | Included |
| Slow query log analysis | Not included | Not included | Included |
| Indexes and materialised views applied | Not included | Not included | Included |
| Scheduled refresh for heavy reports | Not included | Not included | Included |
| Order | Select | Select | Select |
Add what you need
Choose the size
Add what you need
Your total€500
ContinueThe standard price, plus whatever you add. Confirmed in writing before anything starts; nothing is charged until you accept it.
Questions
Which databases do you query?
PostgreSQL, MySQL, SQL Server, SQLite, BigQuery and Snowflake for SQL, and MongoDB, Firestore and DynamoDB for NoSQL.
Will you change our data?
Not without permission. Most work is read-only. Any change, such as an index or a view, is agreed with you first.
Why do two reports show different totals?
Usually because they define something differently: what counts as a customer, a sale or a month. We find the difference and write it down.
Related searches
Related work
One-timeDatabase design and optimisationA database structure that keeps data correct and queries fast, designed new or repaired in place.from €290one-time
ScopedReporting dashboardThe numbers you keep asking for, in one place, updating themselves.from €890on scope
One-timeData cleaningMessy spreadsheets and CRM data deduplicated, standardised and ready to use.from €290one-time
Order it
Standardised enough to order on its own. The price is confirmed in writing before anything starts.