skill-system-postgres

Creates a PostgreSQL schema for tracking skill executions and enforcing policies.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/arthur0824hao/skills --skill skill-system-postgres
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: skill-system-postgres
Source: https://github.com/arthur0824hao/skills/tree/main/skills/skill-system-postgres
Command: npx skills add https://github.com/arthur0824hao/skills --skill skill-system-postgres

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill provides a robust PostgreSQL database schema for managing observability and policy enforcement within the skill system, ensuring controlled and auditable execution of AI agent actions.

Core Features & Use Cases

  • Policy Management: Define and enforce allowlists for skill effects and execution contexts.
  • Execution Logging: Record detailed logs of skill runs, including status, duration, and metrics.
  • Use Case: When an agent needs to perform a database write operation, this skill can be used to check if the requested effect is permitted by the current policy profile before execution.

Quick Start

Use the skill-system-postgres skill to check if the effects 'db.write' and 'db.read' are allowed by the 'dev' policy profile.

Frequently Asked Questions about skill-system-postgres

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

FAQPage Schema
How do I enforce policy profiles for database write operations in a PostgreSQL agent system?▼

To enforce policy profiles for database write operations, this Skill provides a PostgreSQL schema that checks if requested effects like db.write are permitted by a defined allowlist before execution. This ensures controlled and auditable agent behavior.

What is the best way to log AI agent execution runs and step-level events in PostgreSQL?▼

The best way to log AI agent execution runs in PostgreSQL is by using this Skill's schema to record detailed logs of step-level events, including run status, duration, and metrics for full observability and auditability of agent actions.

How do I set up an allowlist for skill effects and execution contexts?▼

You set up an allowlist for skill effects by defining policy profiles within the provided PostgreSQL schema. This mechanism enforces controlled execution by validating requested actions against the allowed contexts before any agent operation proceeds.

Does this Skill support both database read and write operations for policy checks?▼

Yes, this Skill supports both database read and write operations for policy checks. It enables you to verify whether effects like db.read and db.write are allowed by a specific policy profile, such as the dev profile, before execution.

When do I need a dedicated PostgreSQL schema for agent observability and policy enforcement?▼

You need a dedicated PostgreSQL schema for agent observability and policy enforcement when you must auditable control over AI agent behavior. It manages policy profiles and logs step-level execution events to ensure actions are permitted and recorded.