database

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

1|Updated Jan 30, 2026
One-click install
npx skills add https://github.com/jieni777/opencode-config-backup --skill database-jieni777
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/jieni777/opencode-config-backup/tree/main/skills/database
Command: npx skills add https://github.com/jieni777/opencode-config-backup --skill database-jieni777

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This tool helps developers connect to PostgreSQL and MySQL databases and execute SQL queries, view table structures, and manage data with ease, reducing setup time and manual configuration.

Core Features & Use Cases

  • Database connections: establish and reuse connections to PostgreSQL or MySQL databases.
  • Query execution: run SELECT, INSERT, UPDATE, and DELETE statements and return results.
  • Schema discovery: describe tables to inspect columns and types.
  • Use Case: quickly validate that your credentials work and verify table structures during development.
  • Security: encourages using read-only users for queries and safe data handling.

Quick Start

Connect to your PostgreSQL or MySQL database and run a simple query to verify connectivity.

Frequently Asked Questions about database

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

FAQPage Schema
How do I run SQL queries on a PostgreSQL or MySQL database?

To run SQL queries on a PostgreSQL or MySQL database, provide a valid connection string to execute SELECT, INSERT, UPDATE, or DELETE statements and return results directly for ad-hoc querying and data modification.

What is the best way to inspect database schema and list tables?

The best way to inspect database schema is using schema discovery functions like list_tables and describe_table, which inspect table structures, columns, and types to verify your database setup during development.

Can I execute database transactions for multiple SQL statements?

Yes, you can execute database transactions to run multiple SQL statements as a single unit of work using the execute_transaction function, applying to safe data modification in development and operations workflows.

Do I need a specific database connection string to connect to PostgreSQL?

Yes, you need a valid connection string to connect to PostgreSQL or MySQL databases, enabling you to quickly validate that your credentials work and establish reusable connections for querying.

Should I use a read-only user for database queries and schema exploration?

Yes, you should use a read-only user for database queries and schema exploration to ensure safe data handling, preventing unintended data modification while inspecting table structures and running SELECT statements.