Execute SQL and Ecto queries to inspect database states and logs.
npx skills add https://github.com/ityonemo/pepper --skill investigations
Please help me install this Agent Skill. Skill: investigations Source: https://github.com/ityonemo/pepper/tree/main/.claude/skills/investigations Command: npx skills add https://github.com/ityonemo/pepper --skill investigations
This Skill provides tools and techniques to investigate database states, debug pipeline issues, and explore data for troubleshooting.
mcp__tidewave__execute_sql_query.mcp__tidewave__project_eval.mcp__tidewave__get_logs.users table for their record and check the events table for recent activity related to their account.Use the investigations skill to check the last 20 error logs.
High-intent search queries and answers about installing and using this skill.
Database debugging through SQL queries allows you to execute arbitrary statements directly against the database to inspect table states. You can analyze user records, event sourcing data, and background job queues to pinpoint pipeline issues.
Yes, running Ecto queries provides structured data access for application investigation. This approach enables you to evaluate project-specific query logic to explore database states and troubleshoot reported user issues more safely than raw SQL.
Inspecting application logs for errors and warnings is best handled through a dedicated log retrieval function. This allows you to quickly pull recent error logs to identify pipeline failures and correlate them with database states during troubleshooting.
Troubleshooting a reported user issue involves querying the users table for their specific record and checking the events table for recent activity. This database investigation approach links user accounts to their latest event sourcing data.
Yes, database investigation supports analyzing background job queues. You can execute direct SQL queries against the database to inspect the queue tables, helping you debug pipeline issues and identify stalled or failed background jobs.
Direct SQL is needed for database debugging when you require arbitrary, ad-hoc queries without framework constraints. Ecto queries offer structured data access, while raw SQL provides flexible exploration for complex event sourcing data analysis and troubleshooting.
huydepzai121Execute PostgreSQL psql commands for connections, queries, and administration.
gil-kapelAnalyze log and code error patterns to identify root causes across distributed systems.
HerxinsasaParse and analyze multi-format application and system logs to identify errors and root causes.
interflownexAnalyze MySQL query metrics and resource utilization on Google Cloud SQL.