A client CLI utility for Datasette instances.

Much of the functionality requires Datasette 1.0a2 or higher.

• Run SQL queries against Datasette and returning the results as JSON
• Run queries against authenticated Datasette instances
• Create aliases and store authentication tokens for convenient access to Datasette
• Insert data into Datasette using the insert API (Datasette 1.0 alpha or higher)

Install this tool using pip:

pip install dclient

If you want to install it in the same virtual environment as Datasette (to use it as a plugin) you can instead run:

datasette install dclient

dclient query https://latest.datasette.io/fixtures "select * from facetable limit 1"

To shorten that, create an alias:

dclient alias add fixtures https://latest.datasette.io/fixtures

Then run it like this instead:

dclient query fixtures "select * from facetable limit 1"

Visit dclient.datasette.io for full documentation on using this tool.

To contribute to this tool, first checkout the code. Then create a new virtual environment:

cd dclient
python -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest