SQL Explorer
Demo Environment
This environment resets nightly. Any data or connections you add are public.
SQL Explorer
New Query
Playground
Connections
Logs
Favorites
d
Title
default
tq
base
history_1390634-1970-01-01-MAX_1.db
RMS
179146-Activity_2024-07-12_07-47_101208779_1.db
job_summary_1.db
vehicles_1.db
job_skills_1.db
IMDbMovies-Clean_1.db
sqlite-sakila.db
northwind.db
transactions_1.db
organizations-100000_1.db
maestro-v3.0.0_1.db
job_postings_1.db
Connection
list all columns
Description
SQL
PRAGMA table_info('data');
Save & Run
Save Only
Download...
CSV
JSON
Show Schema
Hide Schema
Format
SQL Assistant
Assistant prompt
"Ask Assistant" to try and automatically fix the issue. The assistant is already aware of error messages & context.
Select All
(?)
Search tables
Ask Assistant
Loading...
Preview
Pivot
Execution time: 2.88 ms
Showing
of 2 total rows.
cid
name
type
notnull
dflt_value
pk
Sum
1.0
Avg
0.5
Min
0.0
Max
1.0
NUL
0.0
Sum
0.0
Avg
0.0
Min
0.0
Max
0.0
NUL
0.0
Sum
0.0
Avg
0.0
Min
0.0
Max
0.0
NUL
0.0
0
0
job_link
TEXT
0
None
0
1
1
job_skills
TEXT
0
None
0
Link to this
Download CSV
Avg. execution: 3.166ms. Query created by admin on 2024-07-05.
History