skills.rest
ZanebonoAlter
ZanebonoAlterCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

pg-diagnose

Diagnose Syntopica backend issues by querying PostgreSQL in a Docker container.

19|4|Updated Jan 11, 2026
Search Tags:#debugging#postgresql#backend#docker#sql#diagnose#health-check
One-click install
npx skills add https://github.com/ZanebonoAlter/Syntopica --skill pg-diagnose
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pg-diagnose
Source: https://github.com/ZanebonoAlter/Syntopica/tree/main/.claude/skills/pg-diagnose
Command: npx skills add https://github.com/ZanebonoAlter/Syntopica --skill pg-diagnose

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Diagnose Syntopica backend issues by querying PostgreSQL in the Docker container named syntopica-postgres.

Core Features & Use Cases

  • Quick health checks for tag processing, job queues, and scheduler status.
  • Detect data integrity problems and embedding gaps by inspecting core tables.
  • Use Case: When the UI shows inconsistent metrics, run these queries to identify root causes in the database.

Quick Start

Run a quick health check against the syntopica-postgres container to verify the database state.

Frequently Asked Questions about pg-diagnose

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

FAQPage Schema
How do I diagnose backend issues by querying PostgreSQL in a Docker container?▼

To diagnose backend issues, you query PostgreSQL directly inside the Docker container using docker exec syntopica-postgres psql -U postgres -d syntopica -c 'SQL' to inspect core tables and identify root causes.

What is the best way to check job queue stalls and scheduler anomalies in PostgreSQL?▼

Checking job queue stalls and scheduler anomalies involves running targeted SQL health checks against the syntopica-postgres database to inspect job statuses and detect processing irregularities.

How do I detect data integrity problems and embedding gaps in a PostgreSQL database?▼

You detect data integrity problems and embedding gaps by executing diagnostic SQL queries on core tables within the PostgreSQL database to identify missing relationships or incomplete data records.

Can I run multi-line SQL queries for complex database status checks via Docker?▼

Yes, you can execute complex multi-line SQL queries for database status checks within the Docker container by utilizing a heredoc syntax to pass extended statements to the psql command-line tool.

Why does the UI show inconsistent metrics and how can PostgreSQL queries help?▼

The UI shows inconsistent metrics due to underlying backend processing failures, which you can identify by running diagnostic PostgreSQL queries to pinpoint tag processing errors or data integrity issues.

Do I need a specific Docker container setup to diagnose Syntopica backend issues?▼

Yes, diagnosing Syntopica backend issues requires access to a running Docker container named syntopica-postgres, allowing you to execute psql commands as the postgres user against the syntopica database.

Related Skills

Explore More Software Engineering Skills→
kubiyabotkubiyabot
16

postgres

Run PostgreSQL queries and admin tasks via the psql CLI.

Official
Advanced
ToonVosToonVos
2

wasp-jobs

Orchestrate asynchronous background jobs in Wasp applications using PgBoss and PostgreSQL.

Community
Intermediate
polaris-dxzpolaris-dxz
1

log-analyzer

Analyze and correlate multi-source logs to detect anomalies and trends.

Community
Intermediate
wpankwpank
11

postgres-job-queue

Implement a PostgreSQL job queue with priority scheduling and SKIP LOCKED batch claiming.

Community
Advanced