SQL Formatter for SQLite
Your data never leaves your browserFormat SQLite for mobile apps and embedded systems.
Example
CREATE TABLE products (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, price REAL); SELECT name, COUNT(*) as ordered FROM products p LEFT JOIN order_items oi ON p.id = oi.product_id GROUP BY p.id;
Tips
- 1Select SQLite dialect.
- 2Dynamic typing preserved.
- 3Format CREATE TABLE clearly.
Frequently Asked Questions
SQLite syntax?
Yes. AUTOINCREMENT, date functions.
.dump?
Yes. All DDL/DML.
CTEs?
Yes, since 3.8.3.