---
id: singlestoredb
version: "1.17.1"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# singlestoredb — Interface to the SingleStoreDB database and workspace management APIs

License: permissive · Maintenance: active · Downloads: 435.9K/mo

## 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 above — 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

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

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 435.9K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

singlestore database connector, python db-api sql client, distributed sql database driver, mysql protocol python interface, vector database similarity search, http data api connector, real-time analytics database, vector-search, distributed-sql, db-api-2.0

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