SQLite AI Python package
This package provides the sqlite-ai extension prebuilt binaries for multiple platforms and architectures.
SQLite-AI
SQLite-AI is an extension for SQLite that brings artificial intelligence capabilities directly into the database. It enables developers to run, fine-tune, and serve AI models from within SQLite using simple SQL queries — ideal for on-device and edge applications where low-latency and offline inference are critical. The extension is actively developed by SQLite AI, some API and features are still evolving.
More details on the official repository sqliteai/sqlite-ai.
Documentation
For detailed information on all available functions, their parameters, and examples, refer to the comprehensive API Reference.
Supported Platforms and Architectures
| Platform | Arch | Subpackage name | Binary name |
|---|---|---|---|
| Linux (CPU) | x86_64/arm64 | sqliteai.binaries.cpu | ai.so |
| Linux (GPU) | x86_64/arm64 | sqliteai.binaries.gpu | ai.so |
| Windows (CPU) | x86_64 | sqliteai.binaries.cpu | ai.dll |
| Windows (GPU) | x86_64 | sqliteai.binaries.gpu | ai.dll |
| macOS (CPU) | x86_64/arm64 | sqliteai.binaries.cpu | ai.dylib |
Usage
Note: Some SQLite installations on certain operating systems may have extension loading disabled by default.
If you encounter issues loading the extension, refer to the sqlite-extensions-guide for platform-specific instructions on enabling and using SQLite extensions.
import importlib.resources
import sqlite3
# Connect to your SQLite database
conn = sqlite3.connect("example.db")
# Load the sqlite-ai extension
# pip will install the correct binary package for your platform and architecture
# Choose between CPU or GPU variant
ext_path = importlib.resources.files("sqliteai.binaries.cpu") / "ai"
conn.enable_load_extension(True)
conn.load_extension(str(ext_path))
conn.enable_load_extension(False)
# Now you can use sqlite-ai features in your SQL queries
print(conn.execute("SELECT ai_version();").fetchone())
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqlite_ai-1.0.5-py3-none-win_amd64.whl.
File metadata
- Download URL: sqlite_ai-1.0.5-py3-none-win_amd64.whl
- Upload date:
- Size: 21.6 MB
- Tags: Python 3, Windows x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d77cc65115cda51d7f9651d15cbd5f36a8a322ee902ff163a8cd6db4967e93a3
|
|
| MD5 |
c13d8bb9f36e6dd47e9398fbc1f7718f
|
|
| BLAKE2b-256 |
523c2633f7114eb483f78646761fbc4e01e8be4a2539a6e7d4294f31346fcf31
|
Provenance
The following attestation bundles were made for sqlite_ai-1.0.5-py3-none-win_amd64.whl:
Publisher:
python-package.yml on sqliteai/sqlite-ai
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_ai-1.0.5-py3-none-win_amd64.whl -
Subject digest:
d77cc65115cda51d7f9651d15cbd5f36a8a322ee902ff163a8cd6db4967e93a3 - Sigstore transparency entry: 2560857803
- Sigstore integration time:
-
Permalink:
sqliteai/sqlite-ai@918e8d0a795d774b23f7607c9da8d45518fab60e -
Branch / Tag:
refs/tags/1.0.5 - Owner: https://github.com/sqliteai
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-package.yml@918e8d0a795d774b23f7607c9da8d45518fab60e -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_ai-1.0.5-py3-none-manylinux2014_x86_64.whl.
File metadata
- Download URL: sqlite_ai-1.0.5-py3-none-manylinux2014_x86_64.whl
- Upload date:
- Size: 22.1 MB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9fdb7f0216b77ab4867eb4f4617fd9022d86c2c0f5f457ad100e2389eeac0249
|
|
| MD5 |
5839fab8c51579fef7f31d773a827e08
|
|
| BLAKE2b-256 |
46916957f8c4486de49db0a283ed54c4314777c16359c02d9f6bafd6d9756a79
|
Provenance
The following attestation bundles were made for sqlite_ai-1.0.5-py3-none-manylinux2014_x86_64.whl:
Publisher:
python-package.yml on sqliteai/sqlite-ai
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_ai-1.0.5-py3-none-manylinux2014_x86_64.whl -
Subject digest:
9fdb7f0216b77ab4867eb4f4617fd9022d86c2c0f5f457ad100e2389eeac0249 - Sigstore transparency entry: 2560857858
- Sigstore integration time:
-
Permalink:
sqliteai/sqlite-ai@918e8d0a795d774b23f7607c9da8d45518fab60e -
Branch / Tag:
refs/tags/1.0.5 - Owner: https://github.com/sqliteai
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-package.yml@918e8d0a795d774b23f7607c9da8d45518fab60e -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_ai-1.0.5-py3-none-manylinux2014_aarch64.whl.
File metadata
- Download URL: sqlite_ai-1.0.5-py3-none-manylinux2014_aarch64.whl
- Upload date:
- Size: 17.9 MB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
93c35d75a8e448c06f75d762cf029a750653e782f776c04ee74a6816205741f1
|
|
| MD5 |
88553f1a1879de1d1ff8146faf6fb8d0
|
|
| BLAKE2b-256 |
4afa6643e97bbf6ecbd1bde77ee66d8fd74bba093abfba5b547fb7e470c30ac5
|
Provenance
The following attestation bundles were made for sqlite_ai-1.0.5-py3-none-manylinux2014_aarch64.whl:
Publisher:
python-package.yml on sqliteai/sqlite-ai
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_ai-1.0.5-py3-none-manylinux2014_aarch64.whl -
Subject digest:
93c35d75a8e448c06f75d762cf029a750653e782f776c04ee74a6816205741f1 - Sigstore transparency entry: 2560857346
- Sigstore integration time:
-
Permalink:
sqliteai/sqlite-ai@918e8d0a795d774b23f7607c9da8d45518fab60e -
Branch / Tag:
refs/tags/1.0.5 - Owner: https://github.com/sqliteai
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-package.yml@918e8d0a795d774b23f7607c9da8d45518fab60e -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_ai-1.0.5-py3-none-macosx_11_0_arm64.whl.
File metadata
- Download URL: sqlite_ai-1.0.5-py3-none-macosx_11_0_arm64.whl
- Upload date:
- Size: 4.5 MB
- Tags: Python 3, macOS 11.0+ ARM64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2ff70ae3c16758c7a7d96645b3199b5cbfd2c7b64c3fc443da3870fa7077cf81
|
|
| MD5 |
26bf9a9d5d99cb91bd9ccf67b801aa41
|
|
| BLAKE2b-256 |
6d6d491aae455568db32b574b4bcae0512a8c178079636d5e5bdf920f1e80b61
|
Provenance
The following attestation bundles were made for sqlite_ai-1.0.5-py3-none-macosx_11_0_arm64.whl:
Publisher:
python-package.yml on sqliteai/sqlite-ai
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_ai-1.0.5-py3-none-macosx_11_0_arm64.whl -
Subject digest:
2ff70ae3c16758c7a7d96645b3199b5cbfd2c7b64c3fc443da3870fa7077cf81 - Sigstore transparency entry: 2560856721
- Sigstore integration time:
-
Permalink:
sqliteai/sqlite-ai@918e8d0a795d774b23f7607c9da8d45518fab60e -
Branch / Tag:
refs/tags/1.0.5 - Owner: https://github.com/sqliteai
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-package.yml@918e8d0a795d774b23f7607c9da8d45518fab60e -
Trigger Event:
push
-
Statement type:
File details
Details for the file sqlite_ai-1.0.5-py3-none-macosx_10_9_x86_64.whl.
File metadata
- Download URL: sqlite_ai-1.0.5-py3-none-macosx_10_9_x86_64.whl
- Upload date:
- Size: 4.5 MB
- Tags: Python 3, macOS 10.9+ x86-64
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a47308a4e9134860419e526eac21012deae54e7537d0dd680b3144eb6781ea87
|
|
| MD5 |
573502b8e9841c55d40c513ac766f635
|
|
| BLAKE2b-256 |
0fa9c26947399cd2682036684e38e6cf681994906994f700e9a832a525ae3cf0
|
Provenance
The following attestation bundles were made for sqlite_ai-1.0.5-py3-none-macosx_10_9_x86_64.whl:
Publisher:
python-package.yml on sqliteai/sqlite-ai
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqlite_ai-1.0.5-py3-none-macosx_10_9_x86_64.whl -
Subject digest:
a47308a4e9134860419e526eac21012deae54e7537d0dd680b3144eb6781ea87 - Sigstore transparency entry: 2560856968
- Sigstore integration time:
-
Permalink:
sqliteai/sqlite-ai@918e8d0a795d774b23f7607c9da8d45518fab60e -
Branch / Tag:
refs/tags/1.0.5 - Owner: https://github.com/sqliteai
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-package.yml@918e8d0a795d774b23f7607c9da8d45518fab60e -
Trigger Event:
push
-
Statement type:
