Dev tools · alternatives · 2026

24 alternatives to Datasette – Create and publish an API for SQLite databases

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, …

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… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Datasette – Create and publish an API for SQLite databases launched in 2017; newer entries below may have overtaken it.

1. 1DP
   Datasette Publish – Turn CSVs into a SQLite-Backed JSON API▲101

   2018 · publish.datasettes.com · its alternatives →

2. 2SO
   SQLite Online – 11 years of solo development, 11K daily users▲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

   2025 · sqliteonline.com · its alternatives →

3. 3
   SQLSite – serve simple websites, APIs and files directly from SQLite▲52

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

   2020 · github.com · its alternatives →

4. 4
   SQLite JavaScript - extend your database with JavaScript▲199

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

   2025 · github.com · its alternatives →

5. 5
   Base, an SQLite database editor for macOS▲693

   I recently released v3 of Base, my SQLite editor for macOS. The goal of this app is to provide a comfortable native GUI for SQLite, without it turning into a massive IDE-style app. The coolest features are - That it can handle full altering of tables, which is quite finicky to do manually with SQLite. - It has a more detailed display of column constraints than most editors. Each constraint is shown as an icon if active, with full details available on clicking the icon. This update also adds support for attaching databases, which is a bit fiddly with macOS sandboxing. I'd love to hear any…

   2025 · menial.co.uk · its alternatives →

6. 6
   NoSQL, but it's SQLite▲98

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

   2024 · gist.github.com · its alternatives →

7. 7SA
   Squirrelbyte – a SQLite-based JSON document server▲118

   2021 · squirrelbyte.com · its alternatives →

8. 8DU
   Doculite – Use SQLite as a Document Database▲160

   Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. Reasons: 1) Using an SQL Database meant having less flexibility and iterating slower. 2) Alternative, proven Document Databases only offered client/server support. 3) No network. Having SQLite server-side next to the application is extremely fast. 4) Replicating Firestore's API makes it easy to use. 5) Listeners and real-time…

   2023 · npmjs.com · its alternatives →

9. 9
   Octo – Generate a serverless API from an SQL query▲241

   2020 · octoproject.github.io · its alternatives →

10. 10
    Datasette Desktop, macOS App for SQLite and CSVs▲22

    2021 · datasette.io · its alternatives →

11. 11
    MongoDB Protocol for SQLite▲147

    A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.

    2023 · github.com · its alternatives →

12. 12
    Restdb.io – a plug and play database service▲101

    Simple online database service in the cloud with NoSQL, REST API, low code javascript hooks, MongoDB support and more. Perfect for API automation, custom development, enterprise, backoffice, serverless backends, database driven websites. It provides easy collaboration and data management with secure

    2016 · restdb.io · its alternatives →

13. 13
    JSON Api▲175

    Hosted API's to develop your app for free 🙌

    2020 · jsonapi.co · its alternatives →

14. 14
    Create apps from GraphQL APIs without writing code▲75

    Create apps from the world's data.

    2020 · graphiteapps.com · its alternatives →

15. 15DA
    Datapane – A new way to build reports, dashboards, and apps in Python▲55

    Hello HN! We’re Leo and Mandeep, founders of Datapane (https://datapane.com). We're building a way to create reports, dashboards, and web apps from your existing data using Python. Think of it as a combination of React and htmx, specifically designed for the Python data stack. Our GitHub is https://github.com/datapane/datapane and you can try building a report or app in ~2 minutes on Codespaces: https://try.datapane.com We started building Datapane at our previous start-up, where we struggled to deliver ML model results to clients. Much to our…

    2023 · its alternatives →

16. 16
    Distributed SQLite on FoundationDB▲150

    Hello HN! I'm building mvsqlite, a distributed variant of SQLite with MVCC transactions, that runs on FoundationDB. It is a drop-in replacement that just needs an `LD_PRELOAD` for existing applications using SQLite. I made this because Blueboat (https://github.com/losfair/blueboat) needs a native SQL interface to persistent data. Apparently, just providing a transactional key-value store isn’t enough - it is more easy and efficient to build complex business logic on an SQL database, and it seems necessary to bring a self-hostable distributed SQL DB onto the platform.…

    2022 · github.com · its alternatives →

17. 17
    A parser for sqlite databases to implement full ALTER TABLE support▲19

    A parser for SQLite create table sql statements. Contribute to marcobambini/sqlite-createtable-parser development by creating an account on GitHub.

    2018 · github.com · its alternatives →

18. 18WM
    We made a real-time editor for web database apps▲121

    2018 · demo.hyperfiddle.net · its alternatives →

19. 19
    Graphweaver – Instant GraphQL API on Postgres, MySQL, SQLite and More▲74

    Graphweaver is an open-source GraphQL API Server that can connect many data sources to create a single API. Create a headless CMS, API Gateway, BaaS or use it as a BFF.

    2023 · github.com · its alternatives →

20. 20
    TABLUM.IO▲159

    Turn CSV, XML & JSON into a live analysis-ready SQL database

    2023 · tablum.io · its alternatives →

21. 21
    Datapane▲73

    Build and publish interactive data reports using Python

    2020 · docs.datapane.com · its alternatives →

22. 22
    SQL workbench in the browser▲117

    Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.

    2024 · sql-workbench.com · its alternatives →

23. 23
    Apisentris▲132

    Convert any databases to APIs

    2020 · its alternatives →

24. 24
    Mongita is to MongoDB as SQLite is to SQL▲126

    "Mongita is to MongoDB as SQLite is to SQL". Contribute to scottrogowski/mongita development by creating an account on GitHub.

    2021 · github.com · its alternatives →

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →