database

Manage and query SQL and NoSQL databases with schema and data operations.

Updated Mar 1, 2026
One-click install
npx skills add https://github.com/zangxin75/openclaw-skills --skill database-zangxin75
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/zangxin75/openclaw-skills/tree/main/database
Command: npx skills add https://github.com/zangxin75/openclaw-skills --skill database-zangxin75

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires curl, jq, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the complex tasks of interacting with and managing various types of databases, allowing for efficient data retrieval and structural adjustments without deep technical expertise.

Core Features & Use Cases

  • Query Execution: Run both SQL and NoSQL queries to fetch specific data.
  • Schema Management: Create, alter, and drop database schemas and tables.
  • Data Operations: Import and export data, and perform backup and restore operations.
  • Use Case: You need to quickly retrieve a list of all active users from a PostgreSQL database. You can ask the Skill to "Show all users from the 'users' table where 'status' is 'active'".

Quick Start

Connect to the PostgreSQL database and list all tables.

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 to fetch specific data from a PostgreSQL or MySQL database?

To run SQL queries and fetch specific data from PostgreSQL or MySQL, you can use this database management Skill to execute statements and retrieve active records directly from your tables.

Can I manage database schemas and perform data operations for both SQL and NoSQL databases?

Yes, you can manage database schemas and perform data operations for SQL and NoSQL databases, including creating, altering, and dropping tables across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.

What's the best way to backup and restore data across multiple database systems?

The best way to backup and restore data across multiple database systems is by using a unified management Skill that supports exporting and importing data for PostgreSQL, MySQL, SQLite, MongoDB, and Redis.

Do I need curl and jq installed to perform database metadata operations?

Yes, you need curl and jq installed on your system, as these dependencies are required specifically for executing database metadata operations during your management tasks.

How does schema management work for NoSQL databases like MongoDB and Redis?

Schema management for NoSQL databases like MongoDB and Redis works by allowing you to create, alter, and drop structural definitions, enabling efficient data retrieval and structural adjustments without deep technical expertise.

What should I do if my database queries are not returning the expected active user records?

If your database queries are not returning expected records, verify your SQL syntax and table schema management, then use the Skill to execute precise query statements filtering by specific status fields like 'active'.