SQLite Pro: a SQLite database editor that behaves like a desktop tool on Android

SQLite Pro app icon By the NAXTECH team · Published 27 Sept 2026 · Updated 7 Nov 2026 · Hands-on with v2.0
SQLite Pro — a SQLite database editor showing a table of rows and a SQL query editor on an Android phone
SQLite Pro opens any .db file on your phone, shows the rows in a spreadsheet-style grid, and runs real SQL.

SQLite Pro at a glance

What it is
A SQLite database manager for browsing, editing and querying .db files.
Platform
Android · works fully offline, no account needed — everything stays on the device.
Opens
.db, .sqlite, .sqlite3 and .db3 files.
Export
CSV, JSON or TSV — via Save as, the share sheet, or the clipboard.
Templates
30 ready-made schemas across Business, Personal, Health and Learning.
Best for
Developers, students and anyone who needs to look inside a SQLite file.

You pull a .db file off a device or out of an app's backup, and now you need to actually see what is inside it — but the only tools that do the job properly live on a laptop. On a phone you are usually stuck with a viewer that lists tables and little else. SQLite Pro was built to close that gap: a database manager that opens the file, shows you the rows, and lets you run real SQL, all on the handset in your hand.

It is a careful tool, not a toy. SQLite Pro opens .db, .sqlite, .sqlite3 and .db3 files, browses and edits every table, and runs statements the way a desktop client would. Nothing is uploaded — the app needs no account and no storage permission, and every file stays on your device.

A SQL editor that understands your database

The query editor is the centrepiece. It highlights SQL as you type and offers autocomplete for your own tables and columns alongside the full language — window functions like row_number, rank, lag and lead, the json_extract / json_object family, common table expressions with WITH RECURSIVE, and RETURNING. You can run a single statement to inspect one result, or choose Run all to execute a whole script in a single transaction that rolls back automatically if any statement fails, so a half-finished migration never leaves the database in a broken state.

SQLite Pro SQL editor with syntax highlighting and autocomplete suggesting table and column names
The SQL editor with highlighting and table-aware autocomplete.
SQLite Pro template gallery showing ready-made database schemas grouped by category
Thirty ready-made templates, grouped by category.

A data grid that reads like a spreadsheet

Query results and table contents appear in the same spreadsheet-style grid: a sticky header that shows each column's name and declared type, zebra rows, a row-number gutter, numbers right-aligned, and NULL shown explicitly rather than as an empty cell. Tap a column header to sort, and binary columns read as BLOB with their size instead of a wall of bytes. Tap any row to open the row editor and change values in place.

Change things without fear

Editing a real database is nerve-wracking, so SQLite Pro keeps a safety net. Every table session has its own undo and redo history, up to 30 steps deep, and each change is labelled — "Row deleted", "Column dropped" — with a detail line in the toast so you know exactly what reversed. Anything permanent asks first, and before you rename or drop a table the app lists the views and other objects that depend on it.

Import and export without leaving the app

SQLite Pro imports a CSV file straight into a table: it detects the header and delimiter, lets you map columns, and returns a report of how many rows were inserted, how many were skipped, and the exact row number of every issue — with a cancel button for long files. Going the other way, it exports any table or query result to CSV, JSON or TSV, handing the file to Android's "Save as" dialog, the share sheet, or the clipboard. Because saving goes through the Storage Access Framework, the app never asks for broad storage access.

Start from a template, or build from scratch

If you are learning SQL or prototyping an idea, the app ships 30 ready-made templates sorted into Business, Personal, Health and Learning — from a point-of-sale and inventory system to an expense tracker, a recipe book, a gym membership roster and a student records database. Each one previews its tables and columns and inserts sample rows, so you have a working database with real data to query in seconds. You can also create tables and views by hand, duplicate an existing database (structure only if you prefer), or import a .db file you already have.

How to run your first query in SQLite Pro

  1. Open the Databases tab and import a .db file, or create a new one from a Template.
  2. Tap a table to browse its rows in the grid, then switch to the Queries tab.
  3. Start typing SQL — accept the autocomplete suggestions for your table and column names.
  4. Tap Run for one statement, or Run all to execute a script as a single transaction.
  5. Read the results in the grid, then export them to CSV, JSON or TSV.

Good to know

SQLite Pro works entirely offline and keeps your files on the device; the only permission it declares is internet access, used during development. The built-in guide collects short how-tos with copyable SQL examples and a "things that catch new users out" topic, and a local crash-log screen lets you see and share diagnostics if something goes wrong — nothing is sent automatically.

Frequently asked questions

Which file types can SQLite Pro open?

It opens .db, .sqlite, .sqlite3 and .db3 files, and can also import a database file or create a brand-new one.

Can I run real SQL, or only browse tables?

You can run full SQL, including joins, CTEs, window functions and JSON functions — either one statement at a time or a whole script in a single transaction.

Will my data stay private?

Yes. SQLite Pro runs fully offline with no account, and every database stays on your device.

Can I get my data out again?

Any table or query result exports to CSV, JSON or TSV through Save as, the share sheet, or the clipboard.

Get SQLite Pro on Google Play →

Rowcraft: a fast, private database client that fits in your pocket

Rowcraft app icon By the NAXTECH team · Published 15 Sept 2026 · Updated 11 Oct 2026 · Hands-on with v1.0
Rowcraft database client on an Android phone — schema tree and a data grid with staged edits
Rowcraft connects to PostgreSQL, MySQL and more, straight from an Android phone or tablet.

Rowcraft at a glance

What it is
A native database client for browsing and editing your databases from Android.
Platform
Android phone and tablet · dark UI · no Rowcraft server, nothing to sign up for.
Price
Free (PostgreSQL, MySQL and a built-in Sample DB, 3 saved connections); optional Pro upgrade.
Engines
PostgreSQL · MySQL · MariaDB · CockroachDB · ClickHouse · SQLite · Redis · MongoDB · Cassandra.
Built for
Developers, DBAs and data folks who need to check or fix data on the move.
Languages
12, including English, Spanish, German, French, Japanese, Korean, Chinese and Thai.

Production is misbehaving, you are nowhere near your laptop, and the only thing between you and a bad night is one small data fix. On a phone that usually means squinting at an SSH session, or a desktop tool that was never built for a 360 px screen. Rowcraft was made for exactly this moment: a real database client that behaves like a native Android app and makes it genuinely hard to break something by accident.

Rowcraft connects directly to your servers — there is no Rowcraft backend in the middle. Your hosts, passwords and queries never leave the phone, credentials live in the operating system's secure storage, and there is no account to create and no analytics.

One client, nine database engines

Rowcraft speaks to the SQL databases you already run — PostgreSQL, MySQL, MariaDB, CockroachDB, ClickHouse and SQLite — and reaches beyond SQL to Redis, MongoDB and Cassandra. The free tier covers PostgreSQL, MySQL and a built-in Sample DB so you can try every screen with realistic data first, and an SSH tunnel gets you safely through to a private server when you are away from the office.

Rowcraft data grid with a modified cell marked by a tilde glyph awaiting review
Edits are staged in the grid, each marked with its own glyph.
Rowcraft Review and Commit screen showing the exact SQL it will run
Review & Commit shows the exact SQL before anything runs.

Edit your data without holding your breath

The data grid is where Rowcraft earns its name. Changes are staged, never instant: tap a cell to edit it, insert a row, or mark one for deletion, and each change is flagged with a colour and a glyph you can read at a glance — ~ modified, + inserted, − deleted. Nothing touches the database until you open Review & Commit, where Rowcraft shows the exact SQL it is about to run. Open a database marked as production and a red stripe follows you across every screen, with an extra confirmation before any write lands.

A SQL editor with a safety net

Write and run SQL with syntax highlighting, reusable snippets and per-connection history. A built-in query guard reads each statement first and stops to warn you before the dangerous ones — a DELETE or UPDATE with no WHERE, a DROP, a TRUNCATE, a destructive ALTER, or a GRANT. Results open in a fast, virtualised table you can export, or hand to the chart builder to see a quick bar or line graph without leaving the app.

An AI assistant that keeps your data yours

Stuck on a join? The AI assistant turns a plain-English request into one ready-to-run SQL statement with a short explanation. It is bring-your-own-key — OpenAI, Anthropic, Gemini or a custom endpoint — and requests go straight from your phone to the provider you chose. By default it shares only your table and column names, never the rows inside.

The rest of the toolbox

How to edit a table safely in Rowcraft

  1. Add a connection — pick your engine, enter the host, port and credentials, or open the built-in Sample DB.
  2. Open the schema tree and tap a table to load its data grid.
  3. Tap a cell to stage an edit; it is flagged with the ~ glyph and a colour, and nothing is sent yet.
  4. Open Review & Commit to read the exact SQL Rowcraft will run.
  5. Confirm to commit — on a production connection you clear one more guard before anything is written.

Frequently asked questions

Does Rowcraft send my database or credentials to a server?

No. Rowcraft has no backend, so your hosts, passwords and queries stay on the device, with credentials kept in the operating system's secure storage.

Which databases does Rowcraft support?

PostgreSQL, MySQL, MariaDB, CockroachDB, ClickHouse and SQLite, plus Redis, MongoDB and Cassandra; the free tier covers PostgreSQL, MySQL and a built-in Sample DB.

Is the AI assistant private?

Yes. You bring your own OpenAI, Anthropic, Gemini or custom key, and by default only table and column names are shared with your provider, never the data in your rows.

How does Rowcraft prevent accidental data loss?

Edits are staged and applied only at a Review & Commit step, and a query guard warns before a DELETE or UPDATE with no WHERE, a DROP, a TRUNCATE or other destructive statements.

Get Rowcraft on Google Play →