Skip to content
EasySQL
Product

Everything EasySQL can do for your data

From natural-language questions to read-only safety to a fully open SDK — here’s a closer look at the product.

"¿Cuántos pedidos pendientes?"

Hay 18 pedidos pendientes.

Ask in any language

English, Portuguese, Spanish, Mandarin — and 100+ more.

EasySQL keeps your question in the original language the whole way through. No translation round-trips, no awkward word-by-word rendering. The model understands the nuance, including idioms, relative dates and timezone-aware references, and returns the answer in the same language you asked.

  • Detect and respect user language on each query.
  • Schema-aware disambiguation for ambiguous table or column names.
  • Normalize dates and numbers to the user’s timezone and locale.

"Show the last 10 failed login attempts"

10 failed attempts — last one 4 minutes ago.

Read-only by design

Five layers of defense between your data and the network.

EasySQL only ever runs SELECT queries against your database. An AST-level parser rejects any write keyword before the SQL leaves the server. We recommend creating a dedicated database user with SELECT-only permission — even if every other layer failed, your DB would still refuse.

  • AST whitelist on the server: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER are rejected.
  • 30-second query timeout to protect your database from runaway scans.
  • Per-connection rate limit (QPS) to prevent abuse.
  • Encrypted credentials (AES-256) at rest, TLS 1.3 in transit.
  • Full audit log of every generated SQL, exportable on Business plans.

"How many new customers this month?"

You received 148 new customers in May.

Natural language → SQL

See the SQL behind every answer. Audit, tweak, reuse.

EasySQL generates the SQL that answers your question, runs it against your database, and shows you both the result and the SQL statement that produced it. Power users can copy the SQL, edit it, save it as a saved query, or share it with the team.

  • SQL is always shown alongside the natural-language response.
  • Saved queries let you re-run common questions with one click.
  • Schema caching keeps repeated questions fast (~2s median).

"Revenue per product, last 6 months"

Revenue chart generated — top product: Pro Plan. +18% vs last week.

Charts and exports

Bar, line, pie — picked automatically, or ask explicitly.

EasySQL picks the best visualization for the shape of your data: numbers, time series, top-N, distributions. You can also request a specific chart ("as a bar chart") or filter ("only paid orders"). On Starter plans and above, export results as CSV or JSON to plug into your own pipelines.

  • Automatic chart selection: number, bar, line, pie, table.
  • CSV and JSON export on Starter, Pro and Business plans.
  • Saved queries expose the same export endpoints via the API.

"List posts published this week"

12 posts published this week.

Multiple databases & WordPress

MySQL, MariaDB, PostgreSQL — and 1-click for WordPress.

Connect any database reachable over the internet, or use an SSH tunnel / our Docker agent for firewalled setups. For WordPress sites, the official plugin auto-detects your database, installs in 1 click, and exposes EasySQL inside the WP admin — no separate login needed.

  • MySQL 5.7+, MariaDB 10.3+, PostgreSQL 11+.
  • WordPress plugin auto-detects the database and version.
  • SSH tunnel or Docker agent for databases behind a VPN.

POST /v1/query · language=en-US

HTTP 200 · 4 questions returned · 1.8s.

import {'{'} createEasySQLClient {'}'} from '@clearsoft/easysql-sdk';
const client = createEasySQLClient({'{'} apiKey {'}'});
await client.queries.createQuery({'{'} question: '...' {'}'});

Open source SDKs & API

MIT-licensed SDKs in Node.js, Python and PHP.

The entire EasySQL UI is built on top of the public REST API. Our official SDKs are MIT-licensed so you can embed EasySQL inside your own product, build internal tools, or automate recurring analyses. More SDKs (Go, Ruby) are on the public roadmap.

  • REST API with stable, documented endpoints.
  • MIT-licensed SDKs for Node.js, Python and PHP.
  • Webhooks for query lifecycle events (Pro and above).

Try it on your own data

Connect a database in 2 minutes. 100 questions/month free, no credit card.

Start for free Read the docs