Lattice: SQLite Studio
A focused workspace for working directly with local SQLite databases.
Captures d'écran
Fonctionnalités
Open SQLite Files
Open existing .sqlite, .sqlite3, or .db files, or create a new database.
Browse and Edit
Browse table rows, search and filter records, choose visible columns, inspect JSON, and edit data.
Run SQL Queries
Write and run SQL with query history, saved queries, automatic drafts, result limits, and an Explain view.
Import and Export
Import CSV data with mapping checks and export filtered tables or query results as CSV or JSON.
Inspect Database Structure
Inspect columns, indexes, foreign keys, triggers, and table definitions.
Create Backups
Add columns, create structures with SQL, and make a consistent backup while the database is open.
À propos
Lattice is a focused desktop workspace for working directly with local SQLite databases. Open an existing .sqlite, .sqlite3, or .db file, or create a clean database and begin building immediately. Browse real table rows, search and filter records, choose visible columns, inspect JSON, and edit data without losing context. Write and run SQL with query history, saved queries, automatic drafts, configurable result limits, and an Explain view for understanding query plans. Destructive statements can require confirmation, and any database can be opened read-only when you only need to inspect it. Move data in and out with guided CSV import and CSV or JSON export. Import mapping checks required columns before changes begin, and each import runs as a single transaction. Export a complete filtered table or the rows currently shown in a query result. Inspect columns, indexes, foreign keys, triggers, and table definitions. Add columns, create structures with SQL, and make a consistent backup while the database is open. Lattice works with files on your computer. No account is required, and database contents are not uploaded to a cloud service.
Foire Aux Questions
What database files can I open?
You can open existing .sqlite, .sqlite3, or .db files, or create a new database.
Can I work with a database read-only?
Yes. Any database can be opened read-only when you only need to inspect it.
Does Lattice support CSV import and export?
Yes. Guided CSV import checks required-column mappings before changes begin, and exports can be created as CSV or JSON.
Can I understand query execution plans?
Yes. The SQL workspace includes an Explain view for understanding query plans.
Are my database contents uploaded to the cloud?
No. Lattice works with files on your computer, and database contents are not uploaded to a cloud service.
Confidentialité et exigences
- Confidentialité
- No account is required, and database contents are not uploaded to a cloud service.
- Autorisations
- Access to files on your computer.
- Langues
- Chinese (Simplified), Chinese (Traditional), English (United States), French, German, Japanese, Korean, Portuguese, Spanish