Skip to content
EasySQL
Features

Everything EasySQL can do for your data

From natural-language questions to read-only safety, an interactive terminal UI and open SDKs — here’s a closer look at the product.

Features ↓ · Use Cases ↓

easysql query "Top 3 customers by revenue"

3 rows · Acme Corp ($48,120) · Globex ($31,480) · Initech ($22,905).

Interactive TUI & CLI

Query straight from your terminal. Credentials never leave your machine.

The EasySQL CLI runs client-side on your workstation or server. It pushes only schema metadata to our API — credentials never leave your machine. Explore results with an interactive TUI shell, cycle through connections and audit query logs directly in your terminal.

  • Available via npm (@easysql/cli) and standalone cross-platform binaries.
  • Schema-only sync: database credentials stay 100% on your machine.
  • Interactive TUI shell with keyboard navigation, history, and tabular output.

"Show the last 10 failed login attempts"

10 failed attempts — last one 4 minutes ago.

Zero stored credentials & read-only

Your credentials stay encrypted locally. Five defense layers protect your database.

EasySQL only ever runs SELECT queries. Your database passwords are never stored on our servers — they remain encrypted on your own machine using your operating system’s secure Keyring. An AST-level parser rejects any write keyword before the SQL is ever executed.

  • AST whitelist on the server: INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER are rejected.
  • Zero stored passwords: DB credentials stay encrypted on your own machine (OS Keyring).
  • 30-second query timeout to protect your database from runaway scans.
  • Encrypted transit via TLS 1.3; only schema metadata is synced with the API.
  • Full audit log of every generated SQL.

"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).

"¿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.

"List posts published this week"

12 posts published this week.

Multiple databases & WordPress

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

Connect any database reachable over the internet, point to local SQLite files, or use an SSH tunnel 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+, and SQLite.
  • 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 {'{'} createConnector, ConnectorEngine {'}'} from '@easysql/connectors';
const connector = await createConnector({'{'} engine: ConnectorEngine.PostgreSQL, connection: '...' {'}'});
const schema = await connector.introspect();

Open source SDKs & API

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

The entire EasySQL ecosystem 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. Desktop app and web dashboard are on the active roadmap.

  • REST API with stable, documented endpoints.
  • MIT-licensed SDKs for Node.js, Python and PHP.
  • Desktop and web interfaces on the product roadmap.
Use cases

One product, many teams

From e-commerce owners to agencies, from WordPress publishers to data engineers — see how teams use EasySQL to get answers from their data.

E-commerce owners

Track orders, customers and revenue without waiting for custom reports.

Skip the spreadsheet pivot. Ask "revenue per product, last 30 days", "customers who bought twice this quarter", or "refund rate by category". EasySQL connects to your MySQL, MariaDB, or PostgreSQL database, runs the query and returns clean tabular answers.

Ready out of the box

WordPress publishers

Ask your WP database directly from the admin.

The official EasySQL plugin detects your WordPress database on install. From the WP admin, ask about posts, comments, users or any custom post type — no separate login, no extra tooling.

Ready out of the box

SaaS product teams

Self-serve analytics without building a dashboard.

PMs and growth engineers can explore activation, retention and conversion metrics on the fly. No tickets to the data team, no new dashboard to maintain. SQL stays auditable so engineers can verify any answer.

Ready out of the box

Marketing teams

Campaign performance in plain language.

Ask about UTM performance, attribution and conversions without writing SQL. Great for teams that need answers in minutes, not days — and that need to trust the SQL behind every answer.

Ready out of the box

Agencies & consultancies

One tool across all your clients’ databases.

Connect each client’s MySQL or PostgreSQL database once. Switch between them and run the same questions, with the same UX. EasySQL keeps connection metadata isolated per workspace — perfect for agencies handling multiple brands.

Ready out of the box

Education & non-profits

Teach SQL by reading it, not just writing it.

Students and researchers can explore real datasets in plain language, then open the generated SQL to see exactly how the query was built. A friendly on-ramp to data literacy.

Ready out of the box

Try it on your own data

Connect a database in 2 minutes. Free to start, no credit card.

Start for free Integrations →