Database Tools Python Packages

pg-diag

PostgreSQL diagnostic tool

mcdview

Interactive HTML explorer for PostgreSQL data models. A self-contained page generated from a DDL file

darudb

Objects, indexes and queries in one local file, with no server to run. One engine, written in Rust, does the work for every language, and encryption, crash safety and several processes on one file are part of it.

schemap-tool

Make your database understandable to AI coding agents. Schemap analyzes schemas, detects issues, maps relationships, and generates compact AI-ready context files for Claude Code, Codex, Cursor, and other AI tools.

sqlitexplorer

A modern CLI for exploring SQLite databases: inspect schemas, query and search data, compute stats, chart results, diff databases, and import/export from the terminal.

bkndb

Embedded hybrid graph-relational database engine with ACID transactions

pgdesign

Describe your database schema in TOML once, and get DDL, normalization auditing, content-addressed migrations, diagrams, docs, and type-safe client code in Go, Python, TypeScript, Java, Kotlin, and Zig

ckanext-selfinfo

Keep your CKAN healthy! 🩺 ckanext-selfinfo gives admins crucial real-time system, usage, and error telemetry directly in the CKAN interface. Tools for CKAN. Lightweight tracking system.

mcpg

Postgres MCP Server

pg-play

Deterministic PostgreSQL diagnostics orchestrator for automation, tools, and AI agents

biobouncer

Best way to validate gene symbols, ontology terms, variant formats, and other biological database IDs in apps and pipelines

indexpilot

Stop bad PostgreSQL indexes before they reach production.

ch-diag

ClickHouse diagnostic tool

rubydb-python

a database engine for ruby still would love help to further harden

postql

Python library and command-line interface (CLI) tool for interacting with PostgreSQL databases, providing simplified database management, query execution, and result export functionalities.

sqliteproof

Which SQLite tables survived, not which pages broke. Localises corruption to the table and row. Read-only, no dependencies.

rowgen

AI-powered SQL data generator using HuggingFace. Fill your database tables with realistic and context-aware data using AI.