datasette

(★ 11,396)

An open source multi-tool for exploring and publishing data

Reference Links

🌐 Official Homepage ![Documentation Status Explore a demo a video about the project Datasette newsletter Homebrew

Owner Repos

llm ★ 12,379

Access large language models from the command-line

Python
files-to-prompt ★ 2,776

Concatenate a directory full of files into a single prompt for use with LLMs

Python
shot-scraper ★ 2,551

A CLI utility for taking screenshots of websites, recording video demos and scraping sites using JavaScript

Python
sqlite-utils ★ 2,154

Python CLI utility and library for manipulating SQLite databases

Python
tools ★ 1,833

Assorted useful tools, almost entirely generated using LLMs

HTML
claude-code-transcripts ★ 1,670

Tools for publishing transcripts for Claude Code sessions

Python

File Explorer

ZIP Download
  • .coveragerc
  • .dockerignore
  • .git-blame-ignore-revs
  • .gitattributes
  • .gitignore
  • .isort.cfg
  • .prettierrc
  • .readthedocs.yaml
  • CODE_OF_CONDUCT.md
  • codecov.yml
  • Dockerfile
  • Justfile
  • LICENSE
  • MANIFEST.in
  • package-lock.json
  • package.json
  • pyproject.toml
  • pytest.ini
  • README.md
  • ruff.toml
  • setup.cfg
  • test-in-pyodide-with-shot-scraper.sh

# Installation Guide

python
Prerequisites

Setup Steps

pip install datasette

Install Datasette using Python pip.

datasette serve path/to/database.db

Run the Datasette server against a SQLite database file.

Key Commands

pip install datasette

Install the Datasette package from PyPI.

datasette serve database.db

Start a web server with the specified SQLite database.

datasette publish heroku database.db

Deploy Datasette along with the database to Heroku or Cloud Run.

The server runs on port 8001 by default and can be accessed via http://localhost:8001/ in your browser.

# Use via CDN

jsDelivr

jsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.

Link
Example

Release Timeline

Actively Maintained

Command Glossary

Commands referenced in this DOCs, explained below.

🔍

brew install

View Details ▼

Install a Homebrew formula or cask.

brew install {{formula|cask}}

Install a formula/cask:

brew install {{[-s|--build-from-source]}} {{formula}}

Build and install a formula from source (dependencies will still be installed from bottles):

brew install {{[-n|--dry-run]}} {{formula|cask}}

Download the manifest, print what would be installed but don't actually install anything:

🔍

pip install

View Details ▼

Install Python packages.

pip install {{package1 package2 ...}}

Install one or more packages:

pip install {{package1 package2 ...}} {{[-U|--upgrade]}}

Upgrade all specified packages to the latest version, installing any that are not already present:

pip install {{package}}=={{version}}

Install a specific version of a package:

🔍

pip

View Details ▼

Python package manager.
Some subcommands such as `install` have their own usage documentation.

pip install {{package}}

Install a package (see `pip install` for more install examples):

pip install --user {{package}}

Install a package to the user's directory instead of the system-wide default location:

pip install {{[-U|--upgrade]}} {{package}}

Upgrade a package:

🔍

pipx

View Details ▼

Install and run Python applications in isolated environments.

pipx run {{pycowsay}} {{moo}}

Run an app in a temporary virtual environment:

pipx install {{package}}

Install a package in a virtual environment and add entry points to path:

pipx uninstall {{package}}

Uninstall a package:

🔍

serve

View Details ▼

Static file serving and directory listing.

serve

Start an HTTP server listening on the default port to serve the current directory:

serve -p {{port}} {{path/to/directory}}

Start an HTTP server on a specific [p]ort to serve a specific directory:

serve {{[-C|--cors]}}

Start an HTTP server with CORS enabled by including the `Access-Control-Allow-Origin: *` header in all responses:

// repository documentation