Datasette

Explore and publish data with a JSON API and web UI for SQLite databases. Query, visualize, and export data without writing backend code.

What You Can Do After Deployment

1. Open the web UI — browse your domain to see the Datasette interface
2. Upload SQLite databases — place .db files in the data volume to explore them
3. Run SQL queries — execute arbitrary SQL against your databases from the browser
4. Use the JSON API — every page has a .json extension for programmatic access
5. Export data — download query results as CSV or JSON

Key Features

• Interactive web interface for browsing SQLite data
• Full JSON API for every table and query
• Arbitrary SQL query execution
• Faceted search and filtering
• CSV and JSON export
• Plugin ecosystem for charts, maps, authentication, and more
• Canned queries for pre-built reports
• Metadata configuration for descriptions and licensing

License

Apache-2.0 — GitHub