Postgresql Core Schema

What it does

This skill provides access to and understanding of the PostgreSQL core schema. It allows agents to query, analyze, and interact with the fundamental database structures within a PostgreSQL environment. Specifically, it facilitates tasks like identifying table relationships, understanding data types, and generating SQL queries based on schema information.

When to use it

• Database Documentation: Automatically generate documentation for a PostgreSQL database by extracting schema details.
• SQL Query Generation: Assist developers in writing complex SQL queries by providing context about the available tables and columns.
• Data Analysis & Exploration: Quickly understand the structure of a new PostgreSQL database to identify relevant data for analysis.
• Schema Validation: Verify that a database schema conforms to expected standards or best practices.

Key capabilities

• Access to PostgreSQL core schema information
• Table relationship identification
• Data type understanding
• SQL query generation assistance

Example prompts

• "Describe the tables in the 'public' schema."
• "What is the data type of the 'id' column in the 'users' table?"
• "Generate a SQL query to select all columns from the 'products' table where the price is greater than 100."

Tips & gotchas

The skill requires access to a PostgreSQL database. Ensure the agent has appropriate credentials and permissions to connect and retrieve schema information.