---
id: sqlcipher3
version: "0.6.2"
license: MIT
license_treatment: permissive
maintenance: aging
---

# sqlcipher3 — DB-API 2.0 interface for SQLCipher 4.x

License: permissive · Maintenance: aging · Downloads: 238.6K/mo

## What it is and what it does

sqlcipher3 wraps SQLCipher (an encrypted variant of SQLite) and exposes it through Python's standard DB-API 2.0 interface. It is based on pysqlite3 with modifications to work with SQLCipher's encryption layer, allowing you to create and query encrypted SQL databases from Python code. The package includes enhancements over the standard library sqlite3 module, such as user-defined window functions, incremental BLOB I/O, and a native backup API.

Installation offers two paths: building from source (which requires a C compiler and SQLCipher headers) or using prebuilt wheels for common platforms. The repository is actively maintained and has no known security vulnerabilities. It targets Python 3.9 and newer, with prebuilt wheels currently available for Python 3.10 and 3.11 on macOS, Linux, and Windows architectures.

Use it for:

- Building applications that require encrypted local databases without external server infrastructure.
- Migrating from standard SQLite to encrypted storage while keeping DB-API 2.0 compatibility.
- Storing sensitive user data (credentials, personal information) in a file-based encrypted database.
- Protects database files at rest; useful for mobile apps, desktop tools, or embedded systems.
- Incremental BLOB I/O for efficient handling of large binary objects within encrypted databases.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

sqlcipher3 is a Python DB-API 2.0 interface to SQLCipher, providing encrypted SQLite database access with features like user-defined window functions, incremental BLOB I/O, and native backup support.

Yes, if you need encrypted SQLite databases in Python. The package is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and offers prebuilt wheels for common platforms. Install friction is moderate due to C compilation, but wheels reduce friction significantly. Not necessary if standard unencrypted SQLite meets your security requirements.

## Install

pip install sqlcipher3
uv add sqlcipher3
poetry add sqlcipher3

## Installing sqlcipher3

Before you install: Medium install friction due to compiled C extensions; prebuilt wheels are available for Python 3.10 and 3.11 on common platforms (macOS, Linux, Windows), but building from source requires a C compiler and SQLCipher development headers. Repository is actively maintained with a recent commit on 2026-01-08.

License in practice: MIT license permits commercial and private use with minimal restrictions; you may use, modify, and distribute sqlcipher3 freely provided you include the license notice.

Quickstart:

import sqlcipher3

conn = sqlcipher3.connect(':memory:')
conn.execute('PRAGMA key="password"')
cursor = conn.cursor()
cursor.execute('CREATE TABLE test (id INTEGER, name TEXT)')
conn.commit()

Requires Python >= 3.9; prebuilt wheels available for Python 3.10 and 3.11 on major platforms, but other versions may require building from source with a C compiler and SQLCipher development libraries.

Verify before relying:

- Whether prebuilt wheels exist for Python 3.9 or Python 3.12+ versions beyond what the friction evidence shows.
- Performance characteristics and encryption overhead compared to standard sqlite3.
- Compatibility with the separate sqlcipher3-binary package and when to choose one over the other.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: medium
- Maintenance: aging
- Downloads: 238.6K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

encrypted sqlite database python, sqlcipher python binding, encrypted sql database, db-api sqlite encryption, sqlcipher3 python driver, secure database connection, sqlite with encryption, encryption, database-driver, sqlite

[View on SkillFed](https://skillfed.io/packages/sqlcipher3) · [View on PyPI](https://pypi.org/project/sqlcipher3/)