libsql-client

What it is and what it does

libsql-client is a Python SDK for interacting with libSQL databases. It provides both async and synchronous APIs to connect to local SQLite files or remote libSQL servers (sqld) via WebSockets or HTTP. The async client is the primary interface, built on aiohttp, while a synchronous wrapper runs the event loop in a background thread for blocking use cases.

The package supports multiple URL schemes (file:, ws:, wss:, http:, https:, libsql:) to abstract the connection method. It executes SQL queries and returns result sets with row data. The repository is now archived and abandoned, with no releases since 2024-05-03.

Use it for:

• Query a local SQLite database from async Python code without blocking the event loop.
• Connect to a remote libSQL server (sqld) and execute queries over WebSockets or HTTP.
• Build applications that need to switch between local and remote database backends using the same API.
• Use synchronous database access in non-async codebases via the create_client_sync() wrapper.
• Integrate libSQL with existing Python projects that already depend on aiohttp.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Python SDK for connecting to and querying libSQL databases, supporting both local SQLite files and remote libSQL servers via WebSockets or HTTP.

No. The package is abandoned (repository archived, last release 2024-05-03) and receives no maintenance. While it has low install friction and a permissive MIT license, the lack of active development poses risks for long-term compatibility, security updates, and bug fixes. Use only if maintaining a legacy application already using it or if you can commit to forking and maintaining it yourself.

Install

libsql-client on PyPI

pip install libsql-client

uv add libsql-client

poetry add libsql-client

Installing libsql-client

Before you install

Low install friction with a pure-Python wheel. However, the repository is archived and marked abandoned, with the last release in 2024-05-03. Maintenance has ceased.

License in practice

MIT license permits commercial and private use with minimal restrictions. Contributions are automatically licensed under MIT terms.

Quickstart

pip install libsql-client

import asyncio
import libsql_client

async def main():
    async with libsql_client.create_client("file:local.db") as client:
        result = await client.execute("SELECT * FROM users")
        print(result.rows)

asyncio.run(main())

Requires Python 3.7 or later; async usage requires an event loop context.

Verify before relying

• Whether the abandoned repository status affects long-term compatibility with current libSQL server versions.
• Current state of the remote server (sqld) protocol and whether this client remains compatible.
• Security implications of using a package with no active maintenance.
• Whether the package continues to work with modern versions of aiohttp and typing-extensions.

Package facts

Evidence: libsql_client-0.3.1-py3-none-any.whl

Tags

More Database packages