https://sqlook.com

[svg] SQLook - Database Explorer
- # x
[svg] Open Database [svg] Load Example [svg] Export Database [svg]
Visualize [svg] Clear
[                    ]
Viewer
Generator
Query Helper
About

Database Information

File Size: -
Tables: -
Total Rows: -
Last Modified: -

Database Structure

No database loaded

Table Structure

Row Count: -
Indexes: -
Clear Format [-- Query History --]
[                    ]
[                    ]
[                    ]
[                    ]
[                    ]

Execute Query
0 rows 0ms
Copy [CSV       ] Export

Load a database to view results

Database Generator

Database Name: [new_database.db     ]
Create Empty Database Download Database
---------------------------------------------------------------------
Table Name: [                    ]
Quick Templates: ID Column Timestamp Columns User Table Address
Fields Product Table Order Table
Additional Constraints: Unique Default Value Check Constraint Foreign
Key
[                    ] [TEXT    ] [ ] Primary Key [ ] Not Null
x
Add Column Generate CREATE Statement Create Table Save as Template
---------------------------------------------------------------------

Data Population

Number of rows to generate: [10                  ]
Data Templates: Names Companies Addresses Products Dates Numbers
[ ] Generate unique values when possible [ ] Include NULL values
(10%) [ ] Generate related data for foreign keys
Generate Sample Data

Query Helper

Basic Queries

Select All Select Columns Select Distinct Select Where Order By Limit
Results

Joins

Inner Join Left Join Right Join Full Outer Join

Aggregate Functions

Count All Count Distinct Count Group By Average Sum Min/Max

Advanced Queries

Pattern Match IN Clause Between Case Statement

Subqueries

Subquery IN From Subquery Correlated Subquery
SQLook Logo

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.

Load Example Database

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

(c) 2024 SQLook. All rights reserved.

Website * Twitter * Contact
Ready
Rows: 0
Query time: 0ms

Next - x
Clippy
Windows logo
GitHub Twitter Email

Support SQLook

x

If you find SQLook useful, please consider supporting its development
with a donation.

Bitcoin QR Code Bitcoin
Ethereum QR Code Ethereum
Solana QR Code Solana
Cookie Cookie Notice

This website uses cookies to ensure you get the best experience. By
continuing to use this site, you consent to our use of cookies.

Accept Reject