SQLite Query RunnerSQLite 在线查询

Load a .sqlite database and run SQL queries against it entirely in your browser with a WASM SQLite engine.

载入 .sqlite 数据库，用 WASM 版 SQLite 引擎在浏览器里执行 SQL 查询，结果可导出 CSV。

What is SQLite Query Runner?SQLite 在线查询 是什么？

A SQL workbench that runs a real SQLite engine in the browser, compiled to WebAssembly. Load a .sqlite or .db file, type any SELECT, and the result comes back as a table you can export to CSV. The engine is the genuine SQLite library, so the SQL dialect, functions and type affinity are exactly what you get on the command line — which makes it the fastest way to answer a question about a database you only have as a file.

一个把真正的 SQLite 引擎编译成 WebAssembly 跑在浏览器里的 SQL 工作台。载入 .sqlite 或 .db 文件，输入任意 SELECT，结果以表格返回并可导出 CSV。引擎就是官方 SQLite 库，SQL 方言、内置函数与类型亲和性都和命令行一致——当手里只有一个数据库文件时，这是最快得到答案的方式。

How to use sqlite query runner如何使用 SQLite 在线查询

1. Drop the .sqlite / .db file onto the upload area.
2. Edit the query, or press List tables to see the schema.
3. Press Run query and read the result table.
4. Export the result to CSV if you need it elsewhere.

1. 把 .sqlite / .db 文件拖到上传区。
2. 编辑查询，或点"列出表"查看结构。
3. 点"执行"，查看结果表。
4. 需要时把结果导出为 CSV。

Common uses常见用途

• Answer a question about a SQLite file you were given, without installing anything
• Sample rows from a production dump to understand the schema
• Check how a query performs before writing it into an application
• Verify a migration statement against a copy of the database

• 手上只有一个数据库文件时，不装任何东西就查清楚
• 从生产库导出文件里抽样几行，理解表结构
• 在把查询写进应用前，先看看执行效果
• 拿数据库副本验证一条迁移语句

FAQ常见问题