Resources for working with SQL in Observable

Ian Johnson

Observable

Working with SQL

Custom database clients for use with Observable SQL cells.

Database Clients

Play the Knightlab's SQL Murder Mystery game to sharpen your data analysis skills with SQL and the Observable Data Table

SQL Mystery Game

Curated datasets

Shan Carter

SQL + Chart

Mike Freeman

Arrays as SQL

Convert CSV to Parquet

Working With Data

Whether your data is hosted on the web, stored in a database, or saved in a local file, you can access it from Observable with these techniques.

Getting Data In and Out

Excel

Datasets curated to be comprehensive and real, yet simple and friendly. Ideal for learning, teaching and web based demonstration of data analysis and visualization.