A unified database management skill for querying, migrating, and backing up PostgreSQL, MySQL, SQLite, and MongoDB instances.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install jpeng-database-manager
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install jpeng-database-manager using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is jpeng-database-manager?
The jpeng-database-manager is a robust addition to the ecosystem of Openclaw Skills, designed to bridge the gap between AI agents and production-grade databases. It provides a standardized interface to interact with both SQL and NoSQL systems, allowing developers to automate complex data operations through a simple CLI.
By leveraging this skill, users can seamlessly transition between managing relational data in PostgreSQL or SQLite and document-based storage in MongoDB. It serves as a critical layer for developers building data-driven applications who need reliable, scriptable database interactions within their AI-assisted workflows.
jpeng-database-manager Use Cases
- Executing complex SQL or NoSQL queries directly from an AI agent environment.
- Automating database schema migrations and version control across different environments.
- Creating scheduled backups or restoring data from existing snapshots.
- Performing bulk data operations including importing and exporting CSV files for data analysis.
How jpeng-database-manager Works
- The user configures the environment variables to point to the target database instance (PostgreSQL, MySQL, SQLite, or MongoDB).
- The skill invokes the db.py script, which initializes the appropriate database driver based on the defined DB_TYPE.
- The command-line interface parses arguments for specific actions such as query, backup, or migrate.
- For queries, the skill processes the input (either raw strings or file-based) and executes it against the live database.
- The results are captured and returned in a structured JSON format, ensuring compatibility with downstream AI agent processing.
jpeng-database-manager Setup
To integrate this into your collection of Openclaw Skills, configure your environment variables based on your database engine:
# For PostgreSQL/MySQL
export DB_TYPE="postgresql"
export DB_HOST="localhost"
export DB_PORT="5432"
export DB_NAME="mydb"
export DB_USER="postgres"
export DB_PASS="password"
# For MongoDB
export DB_TYPE="mongodb"
export DB_URI="mongodb://localhost:27017/mydb"
jpeng-database-manager Data Schema & Taxonomy
The skill utilizes a structured output format to ensure data integrity and ease of parsing. All operations return a JSON object with the following taxonomy:
| Field | Description |
|---|---|
| success | Boolean indicating if the operation completed without errors. |
| rows_affected | The number of records modified, deleted, or retrieved. |
| rows | An array of objects representing the data records (for query operations). |
| error | (Optional) Contains error details if success is false. |
jpeng-database-manager Advanced Features
- Support for multi-engine workflows, allowing the same agent to manage diverse stacks like MariaDB and MongoDB.
- File-based query execution for managing large, complex SQL scripts safely.
- Integrated CSV export/import utility for easy data portability between systems.
- Automated migration directory scanning to ensure database schemas are always up to date.
SKILL.md
Loading
Related Openclaw Skills
MiniMax PDF Analysis
A powerful multi-modal PDF processing tool that leverages the MiniMax API for text extraction, keyword discovery, and vision-based document analysis.
YouTube Video Editor
An AI-driven editing suite designed to apply the retention-maximizing patterns used by top creators to grow YouTube channels automatically.
api-doc-writer
An expert AI assistant specialized in generating standardized RESTful API documentation and interface specifications.
Email Bridge
A powerful email management bridge that enables AI assistants to monitor accounts, extract verification codes, and handle communications across multiple providers.
Automation Tester Roadmap
A professional career development platform that generates data-driven learning pathways for automation testing professionals.
Word / DOCX
A specialized skill for managing Microsoft Word documents with full support for OOXML structures, styles, and tracked changes.
Featured*
