datasette

What datasette does

Datasette is an open source multi-tool, created and maintained by Simon Willison since 2017, that helps users explore and publish structured data as interactive websites and JSON APIs. Built on Python and SQLite, the product ingests data from CSVs, JSON, and database connections, then exposes faceted search, SQL query interfaces, geospatial analysis (via SpatiaLite integration), and full-text search through a web UI. A 'datasette publish' command enables one-command deployment to Google Cloud Run, Heroku, or Vercel. The product is surrounded by an ecosystem of 44 related tools and 154 plugins, including the companion sqlite-utils library, the llm CLI for large language model interactions, datasette-acl for permissions, datasette-agent for AI-assisted querying, and Datasette Apps for embedding custom HTML applications inside an instance.

The platform targets data journalists, museum curators, archivists, local governments, scientists, and researchers — any user with structured data they wish to publish and analyze. Distribution is entirely open source: the software is distributed through PyPI, GitHub, and Docker Hub, and users self-host the application on their own infrastructure. Development is publicly tracked on GitHub (simonw/datasette), with active release velocity through 2024–2026 and a stream of 1.0 alpha releases (the most recent being 1.0a35 on 23 June 2026) that progressively add write SQL, stored queries, table creation/alteration UIs, and a stable JSON API.

Datasette is not a formal corporation; the legal name on the copyright is Simon Willison, and the project is funded through personal effort, community contributions, and a 2023 GitHub Accelerator participation (disclosed value $0). The core product is licensed under Apache 2.0 with no paid pricing tier — there is no disclosed revenue model, and the project is best characterized as a pre-revenue, individually maintained open source effort rather than a venture-backed company.

Name

datasette

Legal name

Simon Willison

Website

https://datasette.io

Company type

Private

Founded year

2017

Operating status

Operating

Short description

Datasette is an open source Python/SQLite tool created by Simon Willison that lets data journalists, researchers, archivists, and governments explore and publish structured data as interactive websites and JSON APIs, distributed freely via PyPI and GitHub.

Ownership category

akta.pro rank

Product category

Data Exploration and Publishing Platform

NAICS

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services (518)

SIC

Services-Computer Processing & Data Preparation (7374)

akta.pro primary industry

Data Sharing, Data Exchange & Data Marketplace Platforms (HDAEABAH)

akta.pro secondary industry

Metadata, Catalog & Semantic Layer for Data Platforms (HDAEABAJ)

Keywords

• Data exploration tool
• Open source publishing
• SQLite data platform
• Data journalism tools
• JSON API publishing

GTM type

B2B

Offering type

Software

Cost components

Personnel, Technology or R&D, Infrastructure, Operations

Revenue model

1. Open Source / No Direct Revenue: Datasette is an open source project with no stated revenue model. The project is maintained by Simon Willison and appears to be funded through personal effort, community contributions, and potentially consulting or support services. Revenue is not the primary objective for an open source project of this nature.

Pricing tiers

Go-to-market motion1 record

Distribution channels4 records

Marketing channels8 records

Core offering

Datasette is an open-source multi-tool for exploring and publishing data. It imports data from CSVs, JSON, and database connections, then automatically generates an interactive website and a JSON API for that data, with built-in faceted full-text search, SQL query interfaces, and a plugin system. Users can publish a Datasette instance to Google Cloud Run, Heroku, or Vercel with a single 'datasette publish' command.

Product overview

Datasette is an open source multi-tool for exploring and publishing data, functioning as a unified platform for data analysis and web publishing. The core Datasette product enables users to import data from CSVs, JSON, and database connections; analyze and explore it through SQL queries; and publish it as an interactive website with a JSON API. The ecosystem includes 44 related tools and 154 plugins extending its functionality. Key products include the sqlite-utils Python library for database manipulation, datasette-acl for permission management, and datasette-agent for AI-powered natural language database interaction. The ecosystem also includes specialized plugins for GraphQL (datasette-graphql), full-text search, geospatial analysis (SpatiaLite), authentication, and various data export/import capabilities.

Differentiator

Problem solved

Functional benefit

Products and services

• Datasette An open-source multi-tool for exploring and publishing structured data. Datasette imports data from CSVs, JSON, and database connections, then provides an interactive web interface and a JSON API for exploring it, with SQL query support, faceted full-text search, and one-command deployment to cloud hosts.
• sqlite-utils A CLI tool and Python library for manipulating SQLite databases, providing migration utilities, transaction support, and bulk data operations used alongside Datasette.
• llm A CLI utility and Python library for interacting with Large Language Models from providers such as OpenAI, Anthropic, and Gemini as well as locally installed models; powers the AI features of Datasette Agent.
• datasette-acl An advanced permission management plugin for Datasette that provides granular access control over databases, tables, and queries.
• datasette-agent An LLM-powered agent assistant plugin for Datasette providing an extensible AI interface for interacting with SQLite databases using natural language, with support for OpenAI, Anthropic, Gemini, and local models.

Quantifiable outcome

• Publish data to interactive website and API in minutes

Segments5 records

Ideal customer profiles3 records

Technology focussed Yes

API detail

Has API

Yes

API docs

API detail

Core technology

AI maturity

App detail

Integration4 records

AI capability5 records

Feature8 records

Scale indicators3 records

Recent moves6 records

Expansion highlights5 records

Direct peers

• Supabase: Open-source backend-as-a-service built on Postgres with instant APIs, row-level security, and self-hosting. Directly comparable to Datasette as a developer-focused data platform that publishes SQL-backed data as APIs and dashboards, but at much larger enterprise scale and with a commercial layer.
• NocoDB: Open-source Airtable alternative that turns any SQL database into a no-code spreadsheet interface with APIs. Comparable to Datasette as an open-source tool that makes structured data instantly publishable and API-accessible, though NocoDB focuses on no-code spreadsheet UX rather than journalist/researcher workflows.
• Baserow: Open-source no-code database/Airtable alternative with a hosted offering. Comparable to Datasette as an open-source data-publishing platform, but with a commercial SaaS tier and team structure that Datasette lacks.
• Hasura: Provides instant GraphQL and REST APIs over existing databases with fine-grained access control. Closely comparable to Datasette's JSON/GraphQL API generation over SQLite, though Hasura targets enterprise Postgres and supports much larger workloads.
• Directus: Open-source headless CMS and data platform that sits on top of SQL databases and provides APIs, dashboards, and admin UIs. Comparable to Datasette as an SQL-backed data publishing platform with plugin extensibility, though Directus has a formal company and commercial offering.
• Observable: Web-based data exploration and visualization notebook platform popular with data journalists. Comparable to Datasette's exploratory analysis and publishing use cases for journalists and analysts, though Observable is JavaScript-centric and commercially operated.
• CKAN: Open-source data management system widely used by governments and research institutions to publish open data catalogs with APIs. Highly comparable to Datasette for the local-government and open-data publishing use cases, though CKAN is heavier and more institution-focused.

Broad incumbents

• Airtable: Mainstream no-code database/spreadsheet platform with APIs and a broad user base across business, government, and creative teams. Overlaps with Datasette's structured data publishing use case at a much larger scale, but Airtable is proprietary, SaaS-only, and targets non-developer personas.
• Retool: Low-code platform for building internal tools and dashboards on top of databases and APIs. Comparable to Datasette Apps in enabling data-backed application building, but Retool is enterprise-focused and proprietary.

Emerging players

• Grist: Open-source spreadsheet-database hybrid with API access and self-hosting. Comparable to Datasette as an open-source structured data tool with a hosted offering and similar target personas (researchers, NGOs, small teams).

Market position

Strengths5 records

Weaknesses5 records

Competitive moat5 records

Key risks5 records

Key highlights6 records

Customer concentration

• GitHubgithub.com/simonw/datasette
• Xx.com/datasetteproj

Revenue estimate

Valuation estimate

Number of profiles

Profiles1 record

Funding overview

Funding rounds1 record

Investors1 record

Funding detail is available on the Subscription and Enterprise plan.Contact sales →

M&A

Investments

M&A and investment is available on the Subscription and Enterprise plan.Contact sales →

Frequently asked questions about datasette