singlestoredb

What it is and what it does

SingleStoreDB Python SDK is a database driver that connects Python applications to SingleStore, a high-performance distributed SQL database optimized for real-time analytics and vector search workloads. It implements the DB-API 2.0 standard, so it integrates with existing Python database code patterns. The SDK supports two connection methods—MySQL protocol on port 3306 or HTTP Data API on port 9000—and includes a C extension for accelerated data reading when available.

Beyond basic SQL execution, the package offers workspace management APIs for programmatic control of SingleStore Cloud deployments, a Pinecone-compatible vector database interface for similarity search, and result formatting in multiple types (tuples, dicts, named tuples, NumPy arrays, Pandas DataFrames, Polars DataFrames, PyArrow Tables). It also supports optional integrations with SQLAlchemy, dbt, and custom user-defined functions, making it suitable for analytics pipelines, vector search applications, and cloud infrastructure automation.

Use it for:

• Connect Python analytics or ETL scripts to SingleStore for real-time data ingestion and querying.
• Build vector similarity search applications using the Pinecone-compatible vector database API.
• Programmatically manage SingleStore Cloud workspaces, clusters, and regions from Python.
• Return query results directly as Pandas or Polars DataFrames for downstream data science workflows.
• Integrate SingleStore with SQLAlchemy-based ORMs or dbt data transformation pipelines.

Worth the install?

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

Provides a DB-API 2.0 compatible Python interface to SingleStore, a distributed SQL database, supporting both MySQL protocol and HTTP connections with optional C acceleration for faster data reading.

Yes. Active maintenance, low install friction, no known vulnerabilities, and permissive licensing make it a solid choice. Install it if you need a Python driver for SingleStore or are building vector search or real-time analytics applications on that platform. The optional C extension and multiple result formats add practical value for data-heavy workloads.

Install

singlestoredb on PyPI

pip install singlestoredb

uv add singlestoredb

poetry add singlestoredb

Installing singlestoredb

Before you install

Low friction installation via pure Python wheel. Active maintenance with a release 3 days old; last commit 2026-08-11. Six runtime dependencies are all standard, well-maintained packages. No known vulnerabilities.

License in practice

Apache-2.0 permissive license allows commercial and private use with minimal restrictions; suitable for most projects.

Quickstart

import singlestoredb as s2

conn = s2.connect('user:password@host:3306/db_name')
cur = conn.cursor()
cur.execute('SELECT * FROM table_name')
for row in cur:
    print(row)
conn.close()

Requires Python 3.9 or later; C extension acceleration is optional but disabled if system lacks build tools.

Verify before relying

• Performance gain claim ('up to 10x faster') for C extension vs pure Python MySQL connectors needs independent benchmarking.
• Pinecone API compatibility scope and feature parity for vector store operations not detailed in excerpt.
• SQLAlchemy, dbt, and other optional adapter maturity and maintenance status not specified in fact sheet.

Package facts

Evidence: singlestoredb-1.17.1-py3-none-any.whl

Tags

More Database packages