skills.rest
aubrian-halili
aubrian-haliliCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/aubrian-halili/ai-experience --skill backoffice-database
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
pohlai88pohlai88

postgres

Executes read-only SQL queries on configured PostgreSQL databases with schema exploration support.

Community
Intermediate
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
kkn1125kkn1125

dashboard-designer

Design operational dashboards with KPIs, filters, and data tables.

Community
Advanced
jieni777jieni777
1

database

Connect to PostgreSQL or MySQL databases to execute SQL queries and inspect schema.

Community
Intermediate