skills.rest
mitchellvandusen-cell
mitchellvandusen-cellCOMMUNITY
Explore all skills by this author →
GitHub

db-audit

Automate PostgreSQL security and health audits for the InsuranceGrokBot database.

Updated Dec 12, 2025
Search Tags:#performance#multi-tenant#PostgreSQL#SQL injection#database audit#connection pool
One-click install
npx skills add https://github.com/mitchellvandusen-cell/Flask-Webhook --skill db-audit-mitchellvandusen-cell
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-audit
Source: https://github.com/mitchellvandusen-cell/Flask-Webhook/tree/main/.claude/skills/db-audit
Command: npx skills add https://github.com/mitchellvandusen-cell/Flask-Webhook --skill db-audit-mitchellvandusen-cell

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates security and health audits for the InsuranceGrokBot database, identifying potential vulnerabilities and performance issues.

Core Features & Use Cases

  • SQL Injection Audit: Identifies and classifies SQL injection risks in the codebase.
  • Connection Pool Safety: Checks for connection leaks and improper usage patterns.
  • Multi-Tenant Isolation: Ensures queries are scoped correctly for multi-tenant architecture.
  • Missing Indexes: Identifies missing indexes that could improve performance.
  • N+1 Query Detection: Detects and suggests improvements for N+1 query patterns.
  • Transaction Safety: Verifies commit/rollback patterns and uses advisory locks.
  • Data Integrity: Checks for foreign key constraints, NOT NULL constraints, and UPSERT correctness.
  • Use Case: Regularly run this Skill to ensure the InsuranceGrokBot database remains secure and performs optimally.

Quick Start

Run the db-audit skill to perform a full audit of the InsuranceGrokBot database.

Frequently Asked Questions about db-audit

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate a PostgreSQL security audit for SQL injection and connection pool issues?▼

You can automate a PostgreSQL security audit by running a dedicated script that identifies and classifies SQL injection risks while checking for connection pool leaks and improper usage patterns, ensuring database security and health.

What is multi-tenant isolation and how does it affect database health?▼

Multi-tenant isolation ensures queries are scoped correctly for a multi-tenant architecture, preventing data leakage between tenants. It is a critical database health check to maintain strict data boundaries in shared environments.

How can I detect N+1 queries and find missing indexes in PostgreSQL?▼

To detect N+1 queries and find missing indexes in PostgreSQL, run an automated database audit that analyzes query patterns to detect N+1 issues and identifies missing indexes to improve overall performance.

Does database transaction safety require advisory locks and foreign key constraints?▼

Yes, transaction safety requires verifying commit and rollback patterns and using advisory locks, while data integrity checks verify foreign key constraints, NOT NULL constraints, and UPSERT correctness for reliable PostgreSQL operations.

Do I need Python to run a database health and security check?▼

Yes, you need Python installed along with various database tools to perform the analysis. These dependencies are required to execute the automated security and health audits on the PostgreSQL database.

Related Skills

Explore More Software Engineering Skills→
xotongxotong

ce-setup

Diagnose and configure a Compound Engineering environment with guided health checks and setup.

Community
Advanced
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
OmniNode-aiOmniNode-ai
3

check-database-health

Monitor PostgreSQL database health, table statistics, connection pools, and query performance.

Official
Intermediate
Archive228Archive228
746

sql-review

Reviews SQL and ORM queries for injection risks, missing indexes, and bottlenecks.

Community
Intermediate