backoffice-database

Query and inspect the backoffice PostgreSQL database with read-only SQL.

Updated Feb 13, 2026

Search Tags:#database #schema #sql #query #postgres #backoffice

Ready to run

npx skills add https://github.com/aubrian-halili/ai-experience --skill backoffice-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: backoffice-database
Source: https://github.com/aubrian-halili/ai-experience/tree/main/.claude/skills/backoffice-database
Command: npx skills add https://github.com/aubrian-halili/ai-experience --skill backoffice-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill allows users to query the backoffice PostgreSQL database, retrieve schema information, and execute read-only SQL queries, making data exploration efficient and safe.

Core Features & Use Cases

Database Exploration: Discover available databases, schemas, and tables.
Schema Inspection: View column details, data types, and nullability for specific tables.
Read-Only Querying: Execute SELECT, WITH, SHOW, EXPLAIN, and DESCRIBE queries safely.
Use Case: A user needs to find the total number of orders placed last month. They can ask the skill to run a SQL query against the relevant table to get this information.

Quick Start

Use the backoffice-database skill to list all tables in the public schema.

Frequently Asked Questions about backoffice-database

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

FAQPage Schema

How do I run read-only SQL queries against a PostgreSQL database?▼

You can safely execute read-only SQL queries against a PostgreSQL database using SELECT, WITH, SHOW, EXPLAIN, and DESCRIBE statements. The system strictly enforces read-only operations and bounded results for secure data access.

How do I inspect a PostgreSQL schema and list available tables?▼

Inspect a PostgreSQL schema by listing available databases, schemas, and tables. The system supports viewing specific table structures, including column details, data types, and nullability constraints for thorough schema exploration.

Can I modify or write data to the backoffice database using SQL?▼

No, you cannot write or modify data. The system strictly enforces read-only operations, supporting only SELECT, WITH, SHOW, EXPLAIN, and DESCRIBE queries to ensure safe data access and prevent unintended schema modifications.

What SQL commands are supported for querying a backoffice PostgreSQL database?▼

Supported SQL commands for querying a backoffice PostgreSQL database include SELECT, WITH, SHOW, EXPLAIN, and DESCRIBE. These commands enable schema inspection and read-only data retrieval while enforcing bounded results.

How do I explore table structures and column data types in PostgreSQL?▼

Explore PostgreSQL table structures by inspecting specific tables within a schema. The system provides detailed schema information including column names, data types, and nullability constraints for comprehensive backoffice database exploration.