Datasette – Create and publish an API for SQLite databases

In plain words

Datasette is a tool that creates and publishes JSON APIs for SQLite databases without requiring users to write code. It allows developers and data professionals to quickly expose SQLite data through an accessible web interface, making databases queryable and shareable online. The tool works on local machines and can publish databases publicly, supporting advanced features like SQL views for more complex data exploration and analysis.

written from the facts on this page · September 2026

From the sources

I just shipped the first public version of datasette , a new tool for creating and publishing JSON APIs for SQLite databases. You can try out out right now at fivethirtyeight.datasettes.com , where you can explore SQLite databases I built from Creative Commons licensed CSV files published by FiveThirtyEight . Or you can check out parlgov.datasettes.com , derived from the parlgov.org database of world political parties which illustrates some advanced features such as SQLite views . Or you can try it out on your own machine. If you run OS X and use Google Chrome, try running the following: pip3 install datasette datasette ~/Library/Application\ Support/Google/Chrome/Default/History This will…from simonwillison.net

• DP
  Datasette Publish – Turn CSVs into a SQLite-Backed JSON API2018 · publish.datasettes.com · ▲101
• SO
  SQLite Online – 11 years of solo development, 11K daily users2025 · sqliteonline.com · ▲465

  SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

• 
  SQLSite – serve simple websites, APIs and files directly from SQLite2020 · github.com · ▲52

  NO LONGER MAINTAINED! A tool for serving simple websites, JSON APIs and static files directly from a SQLite database - j4mie/sqlsite

• 
  SQLite JavaScript - extend your database with JavaScript2025 · github.com · ▲199

  Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript. - sqliteai/sqlite-js

• 
  NoSQL, but it's SQLite2024 · gist.github.com · ▲98

  Manipulate your SQLite database like a giant Javascript object. Built with o1.

• SA
  Squirrelbyte – a SQLite-based JSON document server2021 · squirrelbyte.com · ▲118

• 
  /dev/null▲468

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲340

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  First Search▲1,093

  The world's best startup advice, curated and searchable.

  Growth · 2017 · review.firstround.com

• 
  New Tesla Roadster▲1,006

  The fastest production car ever made ⚡️

  Life & fun · 2017 · tesla.com

• 
  Tesla Semi▲962

  The safest, and most comfortable truck ever made

  Life & fun · 2017 · tesla.com

• 
  Mockup Generator▲879

  Create attractive product screenshots with just a few clicks

  Growth · 2017 · theapplaunchpad.com

• 
  Landing Pages in MailChimp▲723

  Easy to build, custom landing pages for free

  Growth · 2017 · login.mailchimp.com

• 
  Thieve▲700

  A curated list of the best products on AliExpress

  Commerce · 2017 · thieve.co