Prismiq

Open-source embedded analytics engine for Python.

Installation

pip install prismiq

Quick Start

from prismiq import PrismiqEngine

# Connect to your database
engine = await PrismiqEngine.create(
    database_url="postgresql://user:pass@localhost/mydb",
    exposed_tables=["customers", "orders", "products"]
)

# Get schema
schema = await engine.get_schema()

# Execute a query
result = await engine.execute({
    "tables": [{"id": "t1", "name": "orders"}],
    "columns": [
        {"table_id": "t1", "name": "status"},
        {"table_id": "t1", "name": "total", "aggregation": "sum"}
    ],
    "group_by": [{"table_id": "t1", "column": "status"}]
})

Features

Schema introspection - Discover tables, columns, and relationships
Visual query building - Build SQL from JSON query definitions
Async execution - Non-blocking database operations with asyncpg
Type safe - Full type hints with Pydantic models
Multi-tenant support - Schema-based isolation with Alembic integration

Multi-Tenant Integration

For applications with schema-based multi-tenancy, Prismiq provides SQLAlchemy declarative models and sync table creation:

from sqlalchemy import create_engine
from prismiq import ensure_tables_sync, PrismiqBase

engine = create_engine("postgresql://user:pass@localhost/db")

# Create tables in a tenant-specific schema
with engine.connect() as conn:
    ensure_tables_sync(conn, schema_name="tenant_123")
    conn.commit()

# For Alembic integration, access the metadata:
# PrismiqBase.metadata.tables contains all Prismiq table definitions

See Multi-Tenant Integration Guide for complete documentation.

Documentation

See the main repository for full documentation.

License

MIT

Development Status
- 3 - Alpha
Framework
- FastAPI
Intended Audience
- Developers
License
- OSI Approved :: MIT License
Programming Language
Topic
- Database
Typing
- Typed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

prismiq-0.2.14.tar.gz (204.2 kB view details)

Uploaded Sep 14, 2026 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

prismiq-0.2.14-py3-none-any.whl (152.4 kB view details)

Uploaded Sep 14, 2026 Python 3

File details

Details for the file prismiq-0.2.14.tar.gz.

File metadata

Download URL: prismiq-0.2.14.tar.gz
Upload date: Sep 14, 2026
Size: 204.2 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for prismiq-0.2.14.tar.gz
Algorithm	Hash digest
SHA256	`803d974e59015af1b97ca06ee7014e198bd94501946e4fbf196bb5c849ace706`
MD5	`fb45bf9971540a4394ad58d19daa87b6`
BLAKE2b-256	`f5d676dedf3467f5d11b4f9209493b914749edb344b0fd30fe973f62d7e01564`

See more details on using hashes here.

Provenance

The following attestation bundles were made for prismiq-0.2.14.tar.gz:

Publisher: publish-pypi.yml on statisfy-us/prismiq

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: prismiq-0.2.14.tar.gz
- Subject digest: 803d974e59015af1b97ca06ee7014e198bd94501946e4fbf196bb5c849ace706
- Sigstore transparency entry: 2825869640
- Sigstore integration time: Sep 14, 2026
Source repository:
- Permalink: statisfy-us/prismiq@47a0e2738fe4883bbe85507aa7a456e15f149019
- Branch / Tag: refs/tags/python-v0.2.14
- Owner: https://github.com/statisfy-us
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish-pypi.yml@47a0e2738fe4883bbe85507aa7a456e15f149019
- Trigger Event: release