SQL & Database Editing Tools
Sql Playground
Learn and practice SQL with interactive sample databases. Run queries, see results instantly. Perfect for beginners and testing.
Sql Query Runner
Run SQL queries on SQLite databases in your browser. Write SELECT, INSERT, UPDATE, DELETE queries with instant results. Private, offline.
Sqlite Diff
Compare two SQLite databases and find schema and data differences. Identify added, removed, and modified tables and rows.
Sqlite Merger
Merge multiple SQLite databases into one. Combine tables, handle conflicts, preserve relationships. Browser-based, private.
Sqlite Fts Search
Test SQLite FTS5 full-text search on your data. Create search indexes, run queries, explore ranking. Browser-based demo.
Sqlite Index Advisor
Analyze SQLite queries and get index recommendations. Use EXPLAIN to find slow queries. Browser-based database optimization.
Sqlite Integrity Check
Check SQLite database integrity, detect corruption, verify foreign keys. Run PRAGMA integrity_check. Browser-based diagnostics.
Sqlite Repair
Repair corrupted SQLite databases by recovering tables and data. Run integrity checks and rebuild clean databases. Browser-based.
Sqlite Table Editor
Edit SQLite tables with a spreadsheet-like interface. Add, update, delete rows. Download modified database. Browser-based.
Sqlite Vacuum
Vacuum SQLite databases to reclaim space, defragment, and optimize. Run VACUUM and ANALYZE commands. Browser-based tool.
Browser-Based SQL Execution
Run SQL queries without installing database software. Our SQL Query Runner uses SQL.js to execute SQLite commands entirely in your browser. Load existing databases, create new ones, and run any SQL command with instant results.
Supported SQL Commands
Full SQLite SQL syntax is supported:
- SELECT: Query data with WHERE, JOIN, GROUP BY, ORDER BY
- INSERT: Add new records to tables
- UPDATE: Modify existing data
- DELETE: Remove records
- DDL: CREATE TABLE, DROP TABLE, ALTER TABLE
Database Management
Load SQLite databases from files (.sqlite, .db, .sqlite3) or create new empty databases. Make changes with SQL commands, then download the modified database. Changes exist in memory until you explicitly download.
Query History
Previous queries are saved in session, letting you recall and rerun common operations. Export query results as CSV for use in other tools.
Use Cases
- Data exploration: Query unfamiliar databases to understand their structure
- Quick edits: Make small changes without installing database tools
- Learning SQL: Practice queries in a safe, isolated environment
- Database testing: Verify data before deploying to production
Privacy
Database files are processed entirely in your browser using WebAssembly. No data is uploaded to any server. This is crucial for databases containing sensitive information like user data, credentials, or business records.