Query databases and tables with AI assistance
Project description
datasette-query-assistant
Query databases and tables with AI assistance
Early alpha.
Installation
Install this plugin in the same environment as Datasette.
datasette install datasette-query-assistant
Configuration
This plugin currently requires you to set the ANTHROPIC_API_KEY environment variable to a working Anthropic API key.
Usage
Users with execute-sql permission will gain a database action menu item for "Query this database with AI assistance" which will let them ask a question and be redirected to SQL that will hopefully answer it.
Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd datasette-query-assistant
python3 -m venv venv
source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file datasette_query_assistant-0.1a1.tar.gz.
File metadata
- Download URL: datasette_query_assistant-0.1a1.tar.gz
- Upload date:
- Size: 9.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/5.0.0 CPython/3.12.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 98a723d3e31da9f75ec3caf97970875ac166f07b7e7283c578927adc24569f9b |
|
| MD5 | 7e70a2b2e21a7434b5a5e52c1974270e |
|
| BLAKE2b-256 | 41fb4b8c4aa710262d9707aa930d4c469d5ccf6cec0fa3dc300caa1d3ea72faf |
File details
Details for the file datasette_query_assistant-0.1a1-py3-none-any.whl.
File metadata
- Download URL: datasette_query_assistant-0.1a1-py3-none-any.whl
- Upload date:
- Size: 9.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/5.0.0 CPython/3.12.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | d684ecff759bb93c210210370d7b89ef7de968f5a0f7f8c9b2eac0b3e6141278 |
|
| MD5 | e0229dfe15f43a76918e0f439fc9567b |
|
| BLAKE2b-256 | ce0737be4cb4f53396f6353f2102909fe8bfef60808fec973d8429b19791a519 |
