sqltap
Profiling and introspection for applications using sqlalchemy
Decision gist · record as of 2026-08-14
No. The package is abandoned (last release 2019, no maintenance since 2023) and has high install friction. Modern alternatives like SQLAlchemy's built-in event system, django-debug-toolbar (for Django), or sqlalchemy-utils provide similar profiling with active maintenance. Use sqltap only if you have legacy code already depending on it and cannot migrate.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires SQLAlchemy to be installed separately; package has no declared runtime dependencies and may not be compatible with recent SQLAlchemy major versions.
- High install friction and abandoned maintenance status (last release 2019-05-03, no commits since 2023-05-31) mean this package is not actively maintained.
- It may not work with recent SQLAlchemy versions or modern Python releases without fixes.
License · maintenance · safety
permissive license (permissive) — Licensed under Apache (permissive), so you can use it freely in commercial and open-source projects without copyleft obligations.
last release 2019-05-03 (2660 days) · last repo commit 2023-05-31 · 360 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 150,070 downloads/mo, #10,976 on PyPI
Alternatives
Verify before relying
import sqltap
profiler = sqltap.start()
# ... run your SQLAlchemy queries ...
statistics = profiler.collect()
sqltap.report(statistics, "report.html")- Whether sqltap works with current SQLAlchemy versions (3.0+) or requires pinning to older releases.
- Python version compatibility beyond the unspecified classifier; whether it runs on Python 3.10+.
- Whether WSGI middleware integration still functions with modern web frameworks.
What it is and what it does
sqltap is a profiling library that instruments SQLAlchemy to collect detailed metrics on every SQL query your application executes. It tracks how many times each query runs, how much time it takes, and where in your code it was issued from—giving you visibility into ORM inefficiencies that are easy to miss when working at a high level of abstraction.
You can use it as a standalone profiler (start, run queries, collect and report) or integrate it into WSGI applications via middleware to profile selectively in production. It generates reports in HTML or text format, and supports custom context functions to group statistics by request, page, or other application-level dimensions.
Use it for
- Identify N+1 query problems in SQLAlchemy ORM code by seeing which queries execute repeatedly.
- Measure query execution time to find slow database operations causing application latency.
- Locate the source code lines issuing inefficient queries so you know exactly where to optimize.
- Profile a live WSGI application via the /__sqltap__ endpoint to diagnose production performance issues.
- Generate per-request or per-page query reports to understand query patterns across different application paths.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
No.
The package is abandoned (last release 2019, no maintenance since 2023) and has high install friction. Modern alternatives like SQLAlchemy's built-in event system, django-debug-toolbar (for Django), or sqlalchemy-utils provide similar profiling with active maintenance. Use sqltap only if you have legacy code already depending on it and cannot migrate.
Install
sqltap on PyPI
Before you install
High install friction and abandoned maintenance status (last release 2019-05-03, no commits since 2023-05-31) mean this package is not actively maintained. It may not work with recent SQLAlchemy versions or modern Python releases without fixes.
Requires SQLAlchemy to be installed separately; package has no declared runtime dependencies and may not be compatible with recent SQLAlchemy major versions.
License in practice
Licensed under Apache (permissive), so you can use it freely in commercial and open-source projects without copyleft obligations.
Quickstart
import sqltap
profiler = sqltap.start()
# ... run your SQLAlchemy queries ...
statistics = profiler.collect()
sqltap.report(statistics, "report.html")Verify before relying
- Whether sqltap works with current SQLAlchemy versions (3.0+) or requires pinning to older releases.
- Python version compatibility beyond the unspecified classifier; whether it runs on Python 3.10+.
- Whether WSGI middleware integration still functions with modern web frameworks.
Package facts
| License | permissive license permissive |
| Python support | Not specified |
| Install friction | High. Source build required |
| Runtime dependencies | None |
| Maintenance | Abandoned 2,660 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 150,070 / month, #10,976 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Topic :: Database |
Evidence: sqltap-0.3.11.tar.gz
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlalchemy query profiling”
- sqltapsqltap hooks into SQLAlchemy to collect and report metrics on SQL…
- nplusoneDetects n+1 query problems in Python ORMs (Django, SQLAlchemy,…
- pyramid-debugtoolbarPyramid_debugtoolbar injects an interactive HTML debug toolbar into…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also SQLAlchemy · opentelemetry-instrumentation-sqlalchemy · nplusone · django-queryinspect · sqlbag · django-querycount · Flask-SQLAlchemy · google-cloud-sqlcommenter · sqlalchemy-mixins · pyinstrument