Skip to main content

datasette-explain

PyPI Changelog Tests License

Explain SQL queries executed using Datasette

Installation

Install this plugin in the same environment as Datasette.

datasette install datasette-explain

Usage

The plugin adds JavaScript to the query editor page which will constantly update the page with information gained from running EXPLAIN QUERY PLAN queries against the entered SQL.

This may result in an error message, or it may show the query plan along with any tables used by the query.

Demo

You can see this plugin in action on datasette.simonwillison.net.

Demo of this plugin - a SQL query shows the explain plan as well as the three tables that were used in the query (their names and columns)

Development

To set up this plugin locally, first checkout the code. Then run the tests using uv:

cd datasette-explain
uv run pytest

Metadata

Release files for datasette-explain 0.2.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for datasette-explain 0.2.2
File Size Uploaded
datasette_explain-0.2.2.tar.gz 7.5 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for datasette-explain 0.2.2
File Interpreter ABI Platform
datasette_explain-0.2.2-py3-none-any.whl Python 3 none any Details

Total release size: 16.3 kB

Release files / datasette_explain-0.2.2.tar.gz

Download URL datasette_explain-0.2.2.tar.gz
Size 7.5 kB
Tags Source
SHA-256 checksum
How to use checksums
cb0adeafa75b03dde1200ffa74646dc528bfa244bddbc4815b6df88366b253ff
BLAKE2b-256 checksum
How to use checksums
7a30d442b2dbad756be7ad3c25e847e52a755c0876305ff2081ecf92b56ed338
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Sep 20, 2026.

Transparency log

Release files / datasette_explain-0.2.2-py3-none-any.whl

Download URL datasette_explain-0.2.2-py3-none-any.whl
Size 8.7 kB
Tags Python 3
SHA-256 checksum
How to use checksums
524da2ed998bda531573a762f2d0d425325f89313e6b7c9ba31e18e5dfd4680e
BLAKE2b-256 checksum
How to use checksums
5b00d581cde580b8ef825d408c1f8a99f9e76d90207d67f5e8ef37775e850304
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Sep 20, 2026.

Transparency log

Release history Release notifications | RSS feed

This release

0.2.2 This release

2 release files

0.2.1

2 release files

0.2

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page