SQLite Web Client - Complete with all phpLiteAdmin Features

API:

Databases

Loading databases...

Create Table

Create View

Database Actions

SQL Examples

SELECT * FROM sqlite_master; List all tables List all views List all triggers Table structure List indexes Foreign keys Vacuum database

SQL Query

Table Data

Table Structure

Indexes

Triggers

Views

Advanced Search

Chart

Export

Import

SQL Query

Recent Queries

Run a query to see results

Tables & Views

Select a database first

Table Data

Select a table to view data

Table Structure

Select a table to view structure

Columns

CREATE Statement

Indexes

Select a table to view indexes

Triggers

Select a table to view triggers

Views

Select a database to view views

Advanced Search

Data Visualization

Export Database

Export Format

SQL CSV JSON

Options

Include Structure Include Data Add DROP TABLE Use Transactions Add Comments

Tables to Export

CSV Options

Fields terminated by

Fields enclosed by

Fields escaped by

Replace NULL by

Field names in first row Remove CRLF characters

Import Data

Import Format

SQL CSV JSON

Options

Create tables if not exist Replace existing data Use transactions

CSV Options

Fields terminated by

Fields enclosed by

Fields escaped by

NULL represented by

Field names in first row

Click to select file or drag here

Importing...

Ready

Create Table:

×

Create Index on

×

Index Name

Unique Index

WHERE clause (for partial indexes)

Create Trigger on

×

Trigger Name

Timing

Event

FOR EACH ROW

WHEN expression (optional)

Trigger Body (SQL statements)

Edit Row

×

Insert New Row

×

Add Column to

×

Column Name

Data Type

NOT NULL UNIQUE

Default Value

Edit Column

×

Column Name

Data Type

NOT NULL UNIQUE

Default Value

Rename Database

×

New Database Name

BLOB Viewer

×