query-db

Executes SQL queries against the Feirb PostgreSQL database managed by .NET Aspire.

1|Updated Mar 20, 2026
One-click install
npx skills add https://github.com/mamu7211/feirb-mailclient --skill query-db-mamu7211
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: query-db
Source: https://github.com/mamu7211/feirb-mailclient/tree/main/.claude/skills/query-db
Command: npx skills add https://github.com/mamu7211/feirb-mailclient --skill query-db-mamu7211

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill solves the difficulty of inspecting or debugging the internal state of the Feirb mail client by providing a direct, automated interface to the underlying PostgreSQL database.

Core Features & Use Cases

  • Dynamic Container Access: Automatically detects the active Aspire-managed Postgres container and retrieves the necessary credentials.
  • SQL Execution: Allows for ad-hoc data retrieval, troubleshooting, and verification of system tables like Users, Mailboxes, and ClassificationResults.
  • Use Case: If a user reports an issue with email categorization, you can use this skill to query the ClassificationResults table to verify if the LLM successfully processed the message.

Quick Start

Ask the assistant to query the Users table to list all registered accounts in the database.

Frequently Asked Questions about query-db

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

FAQPage Schema
How do I query a PostgreSQL database managed by .NET Aspire?

To query a PostgreSQL database managed by .NET Aspire, you execute SQL queries directly against the Aspire-managed container. The Skill automates credential retrieval and facilitates data inspection for troubleshooting mail client tables.

Do I need psql installed to inspect an Aspire Postgres container?

Yes, you need local psql installed to inspect an Aspire Postgres container. Active container runtime access is also required to automatically detect the database and retrieve the necessary dynamic credentials.

Can I troubleshoot email classification results in a PostgreSQL database?

Yes, you can troubleshoot email classification results in a PostgreSQL database by running ad-hoc SQL queries against the ClassificationResults table. This verifies if the LLM successfully processed the message and resolves categorization issues.

What is the best way to debug user accounts in a mail client database?

The best way to debug user accounts in a mail client database is to execute direct SQL queries against the Users table. This allows you to list registered accounts and inspect the internal state of the application.

How does dynamic container access work for Aspire database credentials?

Dynamic container access for Aspire database credentials works by automatically detecting the active Aspire-managed Postgres container at runtime. It retrieves the necessary credentials dynamically, eliminating the need for manual configuration.