How to Open and Edit a SQLite Database on iPhone

Short answer: to open a SQLite database (.db, .sqlite, .sqlite3) on an iPhone without a computer, use SQLite Editor & DB Viewer. It browses every table, runs SQL queries, edits rows, and works offline with no account.

When you would do this on a phone

Inspecting a database file someone sent you.
Checking an app's data while away from your desk.
Learning SQL with real tables instead of screenshots.
Looking at an exported dataset before moving it anywhere else.

How to open a SQLite database on iPhone

Install the app from the App Store.
Open the .db, .sqlite or .sqlite3 file from Files, iCloud Drive or the share sheet.
Browse the tables, rows, columns and full schema.
Search across tables and values, or write a query in the SQL editor.

What a good mobile SQLite tool should do

Open common file types from Files and iCloud.
Show the schema, not only the rows.
Run SQL with syntax highlighting.
Build queries visually if you do not want to type SQL: pick tables, columns and filters and the app writes the query.
Edit rows inline and commit changes safely.
Import CSV, JSON and Excel into a table, and export tables or query results to CSV.
Stay local. Your data should not leave the device.

SQLite Editor & DB Viewer does all of the above, and also includes 26 interactive SQL lessons, from SELECT and WHERE to JOIN, which makes it usable for learning as well as inspection.

Frequently asked questions

Can I edit a SQLite file on an iPhone? Yes. You can edit rows inline, add or delete records and commit the changes.

Can I import a spreadsheet into SQLite on iPhone? Yes. CSV, JSON and Excel files can be imported into a table.

Is my database uploaded anywhere? No. It runs locally and offline.

I do not know SQL. Can I still use it? Yes. The visual Query Builder writes the SQL for you.

Download SQLite Editor & DB Viewer on the App Store

On Android: SQLite Editor & DB Viewer on Google Play. Free to download, same features, works offline.

~/cosmovex/untitled.md unsaved

Your work keeps moving.So should you.

Built for the hours spent watching a terminal wait. Something new from this studio is nearly ready — and it isn't for your desk.

Be first to hearComing soon. Details land in the studio newsletter — the same one below, nothing extra to join.

Meanwhile, the toolkit

~/cosmovex/home.md · rendered with Markdown Editor & MD Viewer

A Markdown editor good enough to write its own homepage.

This page is a Markdown document. You're reading the rendered preview — press or hit if you don't believe it. That round trip — plain text in, a clean document out — is what Markdown Editor & MD Viewer does on your Android phone. Free, offline, no account.

markdown Live Server — 2 editors, 1 file

# Two cursors, one document
My phone is hosting this file over Wi-Fi,
and my desktop is ed
> nothing leaves the device — it's your Wi-Fi, your file

▶ Install free on Google Play★ 4.7 on Play · 10,000+ installs · free

## New in v1.5 — watch it work

✓Version History — every save snapshotted; browse and restore

✓Works offline — no account, no cloud — files stay on your device

## Just shipped

Both offline-first, both free to try.

NEWAspenote: Offline Voice to TextIt writes it down. On your phone.Runs Offline · Nothing Uploaded · Summary & Actions

NEWHostPilot: PHP Server & SQLTurn your phone into a web server.PHP 8.4 & SQLite · Stays Running · SQL Console

## The rest of the toolkit

One app per job. No 200 MB do-everything bloat.

App	Job	Rating
Markdown Editor & MD Viewer	Write and preview Markdown on mobile.	4.7★ · 5K+	install ios
WebEva: Build Websites & Code	Build websites from your phone.	4.4★ · 5K+	install ios
PDF Viewer & Editor - AI	Edit, convert & sign PDFs on mobile.	4.9★ · 1K+	install ios
HTML Viewer & Editor - Code	View & edit HTML on mobile.	4.6★ · 1K+	install ios
SQLite Editor & SQL Learner	Manage SQLite databases on mobile.	5.0★ · 1K+	install
Python IDE - Offline Compiler	Write and run Python on your phone.	4.1★ · 1K+	install
Aspenote: Offline Voice to Text	It writes it down. On your phone.	—	install
HostPilot: PHP Server & SQL	Turn your phone into a web server.	—	install
DevBuddy: Offline Dev Toolkit	Your pocket developer toolkit.	—	install ios
ShellPilot - Batch SSH Client	SSH terminal & SFTP on the go.	— · 1K+	install ios
API Client -REST & HTTP Tester	Test APIs anywhere, anytime.	— · 500+	install ios
JSON Editor - Viewer & Format	View, edit & format JSON instantly.	— · 500+	install ios
Java & Kotlin Compiler IDE	Write and run Java on your phone.	4.4★ · 1K+	install
XML Viewer & Editor	View, edit & validate XML on mobile.	— · 5K+	install ios
Open CSV — Viewer & Editor	Open and edit CSV files on mobile.	— · 500+	install ios
JavaScript Editor — React IDE	Run JavaScript and React on your phone.	— · 1K+	install
Image to SVG Converter, Viewer	Convert images to SVG and edit vectors on mobile.	— · 1K+	install
YAML / YML Viewer & Editor	View, edit & validate YAML instantly.	— · 500+	install
Network Toolkit: WiFi IP Tools	Network utilities and diagnostic tools.	— · 500+	install
Code Editor - Text & Notepad	Edit text files on mobile.	— · 500+	install
C / C++ Compiler IDE	Compile & run C and C++ on your phone.	—	install
Diagram Maker: Flow & ERD	Draw flowcharts & ERDs on mobile.	—	install
QR Scanner & Generator	Scan codes with confidence	—	install
Zip Extractor — Unzip RAR 7Z	Open ZIP, RAR, and 7Z files	—	install
PromptCrate: AI Prompt Manager	Your personal AI prompt library	—	install

## Free web tools

Background Remover Snapglow SQLite Viewer QueryDrill

## Questions, answered

Is there a free Markdown editor for Android?

Yes — Markdown Editor & MD Viewer is free on Google Play. It gives you a split-view editor with live preview, syntax highlighting, and HTML/PDF export, and it works fully offline with no account.

Can I edit Markdown from my phone on a desktop browser?

Markdown Editor & MD Viewer includes a Live Server: your phone hosts the document over Wi-Fi and you edit it from any desktop browser with two-way live sync. The file never leaves your device.

Can I make Mermaid diagrams on Android?

Yes — the built-in Mermaid Studio turns plain text into flowcharts, sequence and class diagrams, with pan/zoom and SVG export, right on your phone.

Can I turn Markdown into slides or a PDF on my phone?

Presentation Mode turns any Markdown document into a fullscreen slide deck, and export produces styled HTML or print-ready PDF — all generated on-device.

## From the journal

We're a small studio with one rule: each app does a single job well, works offline, and never asks who you are.