All posts
·4 min read

How PMs Can Query Production Databases Without Writing SQL

You Shouldn't Need to Learn SQL to Do Your Job

If you're a product manager at a SaaS company, you've been in this situation:

You need to know how many users signed up last week. Or whether a specific customer is on a paid plan. Or how many people used a feature you're about to deprecate. The answer exists in your production database. But between you and that answer is a wall called SQL.

So you do what every PM does. You message an engineer.

Some companies try to solve this with dashboards like Metabase, Looker, and Mode. These are great for recurring metrics, but they only answer the questions someone already thought to build a chart for. Your actual day-to-day questions are ad-hoc, messy, and cross-functional.

Other companies give PMs read-only database access and say "learn SQL." Some PMs do. Most don't. And the ones who try often write queries that time out, miss JOINs, or return confusing results because they don't know the schema.


The Actual Solution

What if you could type "how many active organizations do we have and how many team tasks have they created?" and get back:

  • The exact SQL query that was executed
  • A clean table of results
  • Context about which tables were queried
  • Source citations so you can verify the data

That's what Recon does.

Recon connects to your production Postgres database. When you ask a question, it:

  1. Understands your question in plain English
  2. Examines your database schema to find the right tables
  3. Writes and executes real SQL queries
  4. Handles joins, aggregations, and filtering automatically
  5. Returns results in a readable format with full transparency

You see every query that runs. Nothing is hidden. If you want to learn SQL over time, Recon is actually a great teacher: you see exactly how your plain English question translates to a database query.


But It's Not Just the Database

The real power is that database queries are rarely the whole story.

A PM doesn't just need a number from the database. They need context. How does this relate to the tickets in Linear? Is there documentation in Notion? What does the code actually do?

Recon investigates across all of these in a single conversation:

  • Ask about users → Recon queries the database
  • Follow up about feature status → Recon searches Linear
  • Ask for documentation → Recon fetches from Notion
  • Ask how something works → Recon reads the codebase

One conversation. Four systems. The complete picture.


What About Security?

Your database credentials stay secure. Recon runs queries inside a sandboxed environment with read-only access by default: it queries data, it does not modify it. On the Business plan, a full audit trail logs exactly what was asked and what was returned.


Getting Started

Setup takes 5 minutes:

  1. Sign up at askrecon.com
  2. Connect your database (paste your connection string)
  3. Ask a question

No SQL knowledge required. No engineering help needed. No dashboard to configure.

Try it free. 50 queries, no credit card.

Ready to try it?

Start answering your own product questions

Connect your database and query it in plain English. No SQL, no engineers interrupted. 50 free queries, no credit card.