log analyzer database

    1

    Structured log diagnostics and remediation for PostgreSQL, Oracle, and SQL Server with PII redaction.

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    log analyzer database

    Example session with this skill installed

    Analyze these Postgres logs from PROD: 2023-10-27 10:00:05 UTC [1234] postgres@mydb FATAL: remaining connection slots are reserved for non-replication superuser connections.

    • Read your context and instructions
    • Compiled the log analyzer database

    Analysis complete. The log indicates a critical connection limit exhaustion on a production PostgreSQL instance.

    REPORTE DE ANÁLISIS DE LOG — BASE DE DATOS

    ╔══════════════════════════════════════════════════════════════╗
    ║ REPORTE DE ANÁLISIS DE LOG — BASE DE DATOS ║
    ╚══════════════════════════════════════════════════════════════╝

    📋 RESUMEN EJECUTIVO
    Tecnología: PostgreSQL (Versión no declarada)
    Entorno: PROD
    Componente(s): mydb
    Período log: 2023-10-27 10:00:05 UTC
    Total eventos: 1 crítico | 0 warnings | 0 notables
    Diagnóstico breve: Agotamiento de slots de conexión disponibles. La instancia solo permite conexiones administrativas.

    🔴 HALLAZGOS CRÍTICOS

    FATAL: remaining connection slots are reserved: El parámetro max_connections ha sido alcanzado. Solo usuarios con privilegios de superusuario pueden conectarse para realizar tareas de mantenimiento.

    ⚠️ DATOS SENSIBLES

    • Usuario: <span style="color:red;font-weight:bold">postgres</span>
    • Base de Datos: <span style="color:red;font-weight:bold">mydb</span>

    🛠️ PRÓXIMOS PASOS
    1.

    Urgente: Implementar o revisar la configuración de un pooler de conexiones como

    PgBouncer para reducir la carga de conexiones persistentes.
    2.

    Diagnóstico: Ejecutar SELECT * FROM pg_stat_activity; para identificar sesiones inactivas o "idle in transaction" que estén ocupando slots.
    3.

    Configuración: Revisar si el valor de max_connections es adecuado para los recursos de hardware disponibles (memoria RAM/CPU).

    ¿Deseas el reporte como documento entregable (Word/Markdown)?

    Next steps

    • Provide the output of SHOW max_connections; and SHOW shared_buffers;.
    • Check if there are any long-running transactions blocking the autovacuum process.
    • Confirm the current connection pooler settings if one is in use.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Troubleshooting database outages or performance degradation from raw logs is slow and error-prone. This skill parses logs from PostgreSQL, Oracle, and SQL Server to identify severity levels, internal error codes, and resource exhaustion.

    What it does

    • Multi-engine parsing identifies specific formats like PostgreSQL DETAIL/HINT, Oracle ORA-XXXXX codes, and SQL Server spid/Severity levels.
    • Critical event triage categorizes logs into executive summaries, ranging from PANIC/Fatal errors to informational notices.
    • PII redaction flags sensitive data including user credentials, connection strings, hostnames, and real values in deadlock traces.
    • Root cause diagnostics maps errors to specific infrastructure issues like WAL disk saturation, UNDO retention, or transaction log overflows.
    • Remediation guidance suggests specific commands like DBCC CHECKDB or ALTER USER based on the detected failure.

    How it works

    1. Engine Detection: Provide the log snippet for the skill to identify the database engine and environment (DEV/PROD).
    2. Context Validation: The skill asks for missing data such as version, connection pool details (HikariCP/PgBouncer), or supplementary trace files.
    3. Structured Diagnosis: It generates a standardized report including executive summaries and sensitivity warnings.

    Frameworks & tools

    PostgreSQL (all versions), Oracle Database (alert logs, trace files), and Microsoft SQL Server (Extended Events, spid logs).

    Why this beats prompting it yourself

    Generic prompts often confuse severity levels between engines (e.g., SQL Server Severity 16 vs PostgreSQL FATAL). This skill uses engine-specific logic to prevent incorrect recovery suggestions that could lead to data loss or further downtime.

    Use cases

    • Outage analysis for rapid identification of full disks or replication failures.
    • Security audits to find PII leaks caused by high-verbosity logging configurations.
    • Performance tuning to detect slow queries and autovacuum lock contention.
    • Application debugging to trace deadlock graphs and cursor leaks.

    Known limitations

    Does not support NoSQL databases or cloud-native wrappers like Snowflake/DynamoDB. Requires manual provision of .trc files for deep Oracle stack trace analysis.

    Supports only PostgreSQL, Oracle, and SQL Server. Cannot analyze NoSQL or cloud-native DWs. Requires manual input of referenced .trc or supplementary trace files.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 28 days ago

    Permissions

    Write Files
    Listed28 days ago

    What's inside

    Frequently Asked Questions

    The skill automatically redacts sensitive information such as user credentials, connection strings, hostnames, and real data values from deadlock traces before generating its diagnostic report.

    Yes, it supports all versions of PostgreSQL, Oracle Database (including alert logs and trace files), and Microsoft SQL Server; however, it does not currently support NoSQL or cloud-native databases like Snowflake.

    Unlike generic AI prompts, this skill uses engine-specific logic to accurately interpret severity levels—such as distinguishing between a SQL Server Severity 16 and a PostgreSQL FATAL error—to prevent dangerous or incorrect recovery suggestions.

    While the skill identifies high-level issues from standard logs, deep Oracle stack trace analysis requires you to manually provide the relevant .trc files for processing.

    The skill provides a structured diagnostic report, an executive summary of events categorized by severity, and specific remediation commands like DBCC CHECKDB or ALTER USER to resolve the identified issues.

    New in Data & Databases