# SmartQuery — Postgres, MySQL, and SQLite UI

> Postgres, MySQL, and SQLite UI (iPhone/iPad app by SIMON ALBERT MATHEWSON.)

- Source: https://appshunter.io/ios/app/smartquery/id6755796701 (this page in markdown: same URL + `.md`)
- Developer: [SIMON ALBERT MATHEWSON](https://appshunter.io/developer/1856431517)
- Category: Developer Tools, Productivity
- Price: Free
- Age rating: 4+
- Requires: iOS 17.0 · 36 MB
- Languages: American English
- Released: 2025-12-16
- Data updated: 2026-08-15
- User reviews in markdown: https://appshunter.io/ios/app/smartquery/id6755796701/reviews.md

## What is SmartQuery?

Supports PostgreSQL, MySQL, and SQLite. 100% local and open-source.

Get tailor-made queries from a schema-aware AI assistant:
Copilot generates queries based on your database schema, including tables, columns, enums, constraints, and more. Rows are never passed to Copilot.

Insert, update, and delete with ease: 
Generate SQL to modify your data with an intuitive user experience. Includes inputs optimized for each data type.

Bring your data to life with charts:
Easily generate line, bar, and pie charts from your SQL results. Also, Copilot will automatically suggest appropriate charts for generated SQL.

Ask your database anything:
Use natural language to get precise answers from your database. Get prompt suggestions and comfortably explore your data. Generate complex modifications tailored to your database schema.

Thoughtful, customizable design:
SmartQuery has a strong focus on user experience and accessibility. Adjust the theme and primary color to your liking.

Security and transparency:
SmartQuery is open source and 100% local—no accounts, no subscriptions, no cloud. When handling credentials and table data, there is no room for compromise. Here's how we keep things secure and private:
- 100% local: SmartQuery runs entirely on your device. Credentials, connections, queries, and all data stay local. There is no cloud—no accounts, no syncing—so your database access never leaves your machine.
- Your credentials, your device: Connection details and credentials are stored only on your device. Nothing is uploaded to our servers because we don't store user data—everything stays under your control.
- Need-to-know basis: Your data is never stored or logged by us. When you use AI features, only the minimum necessary data (e.g. schema information) is sent to the AI provider—row data is never sent.
- Web best practices: Data is always transferred via HTTPS and protected from man-in-the-middle attacks. The web app is protected against XSS and XSRF attacks and other web vulnerabilities.


## Version history (last 5 releases)

### 1.0.11 — 2026-03-01

SmartQuery is now 100% open-source, local, and free.

### 1.0.10 — 2026-01-24

- Added Plus subscription

### 1.0.9 — 2026-01-19

- Added offline support

### 1.0.8 — 2026-01-18

- Fix MySQL connection issues

### 1.0.7 — 2026-01-16

- Allow multiple login credentials in keychain

## Apps similar to SmartQuery

| App | Rating | Price | Category |
| --- | --- | --- | --- |
| [Tablewright: SQLite Editor](https://appshunter.io/ios/app/tablewright-sqlite-editor/id6759238277) | 5.0 (5) | Free | Developer Tools |
| [PostgreSQL Elite](https://appshunter.io/ios/app/postgresql-elite/id6758619957) | — | Free | Developer Tools |
| [psq - postgres monitor utility](https://appshunter.io/ios/app/psq-postgres-monitor-utility/id6757760191) | 5.0 (1) | Free | Developer Tools |
| [simSQL](https://appshunter.io/ios/app/simsql/id1612446299) | — | Free | Developer Tools |
| [Curly — REST API Client](https://appshunter.io/ios/app/curly-rest-api-client/id6759227355) | — | Free | Developer Tools |
| [PPP Price Planner](https://appshunter.io/ios/app/ppp-price-planner/id6745759050) | — | Free | Developer Tools |

## Related topics

[queries](https://appshunter.io/ios/topics/queries)

---

*Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2026-08-15.*