Powered by TREEEX

From 'What If?' to SQL.
Instantly.

Your data has answers. TeshQ finds them. Query your databases in natural language and get from raw data to a business decision in seconds.

# Install TESHQ
$ pip install teshq
Successfully installed teshq
# Configure your database and API key
$ teshq config --db --gemini
✓ Configuration saved successfully
# Introspect your database schema
$ teshq introspect
✓ Schema introspection complete
# Ask complex questions in plain English!
$ teshq query "List 'power users' who signed up last month and have made more than 5 purchases"
✓ SQL Query Generated:
SELECT c.name, c.email, COUNT(o.id) AS purchase_count
FROM customers c JOIN orders o ON c.id = o.customer_id
WHERE c.created_at >= '2024-12-01'
GROUP BY c.id, c.name, c.email
HAVING COUNT(o.id) > 5
✓ Query executed successfully (14 rows)

Trusted by Developers Worldwide

210+

Commits

5.6K+

Installs

35K+

Queries

Your Data Is Trying to Talk. Are You Listening?

Your data is scattered. Your insights are delayed. Your team is waiting on analysts for every simple query. Sound familiar?

Problem: Scattered Data

"My data is in 5 different places"

Sales, marketing, and customer data live in silos. Getting a complete picture means manual exports, spreadsheets, and hours of work.

Problem: Slow Insights

"I need to wait days for a simple query"

Business questions require technical SQL skills. You're bottlenecked by your data team for every insight you need.

Solution: Instant Answers

"Just ask in plain English"

TESHQ connects all your data sources and turns your questions into perfect SQL instantly. No waiting, no coding required.

Coming Soon in TESHQ Pro

We're building the features you asked for. Get ready for a full-featured data platform, powered by AI.

Interactive Dashboards

Ask a question, get a chart. Save it to a dashboard. All in plain English with a drag-and-drop visual builder.

AI-Powered Forecasting Engine

"Forecast our revenue for the next 6 months based on last year's trend." It's that simple.

Team Collaboration

Share queries, results, and dashboards with your team securely. Add comments and manage versions.

Premium Connectors

Go beyond your database. Query data from Google Ads, Meta Ads, Salesforce, Google Analytics & more, all in one place.

From Question to Answer in 3 Simple Steps

1

Connect

Link your databases (PostgreSQL, MySQL, SQLite). TESHQ automatically understands your schema, relationships, and data structure.

2

Query

Ask questions in natural, plain English. Our AI (powered by Google Gemini) generates perfect SQL with parameters and safety checks.

3

Decide

Get instant results as tables, charts, or exports (CSV, Excel, SQLite). Make data-driven decisions immediately.

Try it with Python:

import teshq

# Initialize the client
client = teshq.TeshQuery(
    db_url="postgresql://user:pass@localhost/mydb",
    gemini_api_key="your-api-key"
)

# Introspect your database
schema = client.introspect_database()

# Ask questions in plain English!
results = client.query(
    "Show me all customers who registered last month"
)

# Get results instantly
print(f"Found {len(results)} customers")

Your AI Data Analyst, Bottled.

Everything you need to turn data into decisions, with none of the usual headaches.

Unified Data Sources

Connect PostgreSQL, MySQL, SQLite databases. Soon: Google Ads, Meta Ads, Salesforce, and more.

Plain-English Queries

No SQL knowledge required. Ask questions naturally, get accurate SQL with smart parameter binding.

Instant Dashboards

Built-in visualization and export to CSV, Excel, or SQLite. Pro tier adds interactive dashboards and forecasting.

Local & Private

Your data never leaves your machine. No cloud storage, no data sharing. Complete privacy and control.

CLI & Python API

Use from your terminal or integrate directly into your Python applications. Full programmatic control when you need it.

Smart Schema Understanding

Automatic relationship detection, index awareness, and sample data analysis for better, more accurate query generation.

The 'Aha!' Moment, On Demand.

From quick insights to complex analysis, TESHQ handles it all.

Customer Analytics

"Find customers from New York who bought 'Product A' but not 'Product B' in the last 6 months."

  • Cohort analysis
  • Churn prediction
  • LTV calculations

Sales Performance

"What's the 7-day-average sales revenue, and compare it to the same period last month?"

  • Revenue tracking
  • Product performance
  • Sales team KPIs

Marketing ROI

"Compare the 30-day conversion rate for users from 'google' vs 'facebook' ad campaigns."

  • Campaign analysis
  • Attribution modeling
  • Channel optimization

Inventory Management

"Show me low-stock items (under 10 units) that sold *more* than 100 units last month."

  • Stock alerts
  • Reorder points
  • Demand forecasting

HR Analytics

"What's the average tenure of employees in the 'Engineering' department vs. 'Sales'?"

  • Headcount reports
  • Retention analysis
  • Performance metrics

Operations & Logistics

"List all orders with a 'shipped' status for more than 3 days but no 'delivered' status yet."

  • Delivery tracking
  • SLA monitoring
  • Process optimization

Simple, Transparent Pricing

Start free, scale as you grow. No hidden fees, no surprises.

Free

Perfect for individuals and exploration

$0 /forever
  • Single database connection
  • Unlimited natural language queries
  • Basic query capabilities
  • Export to CSV/Excel
  • Community support
Get Started Free
Launching Soon

Pro

For teams and power users

$7 /user/month
  • Everything in Free, plus:
  • Unlimited database connections
  • Interactive dashboards & visualizations
  • Premium connectors (Google Ads, Meta)
  • Team collaboration tools
  • Priority support
Launching Soon

Enterprise

For organizations at scale

Custom
  • Everything in Pro, plus:
  • Advanced security & governance
  • SSO, RBAC, audit logs
  • Custom integrations
  • Dedicated support & SLA
  • On-premise deployment option

Don't Just Take Our Word For It

Head of Data Science

Global Fortune 500 Retailer

"TESHQ saved our analytics team hundreds of hours per month. We could finally see ad spend, sales, and customer numbers in one place—no more back-and-forth with analysts."

Product Manager

SaaS Startup

"I'm not technical, but with TESHQ I can answer my own data questions. From 'Why did sales drop this week?' to actionable insights in minutes, not days."

Join 1,200+ weekly active users making data-driven decisions faster

Install. Connect. Interrogate.

Install TESHQ, connect your database, and start asking questions. It's that simple.

# Step 1: Install TESHQ
$ pip install teshq
✓ Successfully installed teshq
# Step 2: Configure (interactive prompts will guide you)
$ teshq config --interactive
Database type (postgresql/mysql/sqlite): postgresql
Database host: localhost
Database name: myapp
Gemini API Key: AIza...
✓ Configuration saved successfully
# Step 3: Introspect your database
$ teshq introspect
✓ Found 12 tables, 145 columns
✓ Detected 8 relationships
✓ Schema saved to db_schema/
# Step 4: Start asking questions!
$ teshq query "How many users signed up last month?"
✓ Generated SQL:
SELECT COUNT(*) FROM users
WHERE created_at >= '2024-12-01'
✓ Result: 1,847 users

Ready to Transform Your Data Workflow?

Join thousands of users who've already made the switch from complex SQL to simple questions. Get started free today.

Start Free Now