Database Information
Database Structure
No database loaded
Table Structure
Load a database to view results
Database Generator
Data Population
Query Helper
Basic Queries
Joins
Aggregate Functions
Advanced Queries
Subqueries
SQLook
A Web Based SQLite Database Manager
Version 1.0.0
About SQLook
SQLook is a modern web-based SQLite database manager with a nostalgic Windows 2000 interface. It combines the power of contemporary web technologies with the classic aesthetics of one of computing's most iconic eras.
Features
Database Management
- Open and create SQLite databases
- Export databases and query results
- Visual database structure viewer
- Real-time database statistics
Query Tools
- Interactive SQL query editor
- Query history tracking
- Query formatting tools
- Results export (CSV, JSON, SQL)
Table Generator
- Visual table creation interface
- Pre-built table templates
- Sample data generation
- Foreign key support
Query Helper
- Common SQL templates
- Interactive examples
- Syntax highlighting
- Context-aware tooltips
Try it out!
Want to explore SQLook's features? Try our example database:
Chinook Database
A sample database representing a digital media store, including tables for artists, albums, media tracks, invoices, and customers.
Technical Details
Built with: HTML5, CSS3, JavaScript, SQL.js
Database Engine: SQLite 3
License: MIT License
Last Updated: January 2024
Credits
Created by Ralph Barendse
Inspired by the Windows 2000 user interface
Built using SQL.js and other open-source technologies