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

We kept finding ourselves looking for good datasets to use to demonstrate, teach and discuss working with data. In our search we realized we'll never find the One True Dataset, so we started developing this collection of curated datasets. 

Staff Pick: Curated Data Sets

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