skills.rest
jholhewres
jholhewresCOMMUNITY
Explore all skills by this author β†’
WebsiteGitHub

database

Execute queries and manage schemas across PostgreSQL, MySQL, MongoDB, Redis, and SQLite.

3|Updated Feb 13, 2026
Search Tags:#database#redis#sql#query#mysql#mongodb#postgres
One-click install
npx skills add https://github.com/jholhewres/goclaw-skills --skill database-jholhewres
Or copy as Structured Prompt for Agentβ–Ό
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/jholhewres/goclaw-skills/tree/main/skills/database
Command: npx skills add https://github.com/jholhewres/goclaw-skills --skill database-jholhewres

SYSTEM DOCUMENTATION & REQUIREMENTS

πŸ’‘ This Skill requires psql, mysql, mongosh, redis-cli, sqlite3, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies interacting with various database systems, allowing you to execute queries, manage data, and perform backups directly from the command line.

Core Features & Use Cases

  • Multi-Database Support: Connects to PostgreSQL, MySQL, MongoDB, Redis, and SQLite.
  • Query Execution: Run SQL or NoSQL queries, import/export data, and manage schemas.
  • Use Case: Quickly retrieve user data from a PostgreSQL database by executing a SQL query, or export a MongoDB collection to a JSON file for analysis.

Quick Start

Use the database skill to connect to a 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 on PostgreSQL and MySQL from the command line?β–Ό

This Skill facilitates executing SQL queries on PostgreSQL and MySQL by interfacing directly with their psql and mysql command-line tools, enabling immediate data retrieval and schema management.

Can I manage both relational and NoSQL databases like MongoDB and Redis together?β–Ό

Yes, you can manage both relational and NoSQL databases together, as this Skill supports direct interaction with MongoDB via mongosh and Redis via redis-cli alongside PostgreSQL, MySQL, and SQLite.

Do I need to install specific CLI tools to query and manage databases?β–Ό

Yes, you must install specific CLI tools such as psql, mysql, mongosh, redis-cli, and sqlite3 on your system to use this Skill for executing queries and managing your databases.

What is the best way to export a MongoDB collection to a JSON file?β–Ό

The best way to export a MongoDB collection to a JSON file is using this Skill to run data export operations through the mongosh CLI, facilitating direct data extraction for analysis.

How do I perform database backups for SQLite and PostgreSQL?β–Ό

You can perform database backups for SQLite and PostgreSQL by using this Skill to execute backup operations directly through their respective sqlite3 and psql command-line interfaces.

Related Skills

Explore More Software Engineering Skills→
PlaneInABottlePlaneInABottle

native-datastore-verifier

Automates post-action datastore verification by querying native databases via CLI.

Community
Intermediate
Datus-aiDatus-ai
1.5k

report-generator

Generate JSON, CSV, or markdown reports from SQL query results.

Official
Basic
MinhmiceMinhmice

database-specialist

Designs and migrates database schemas, policies and queries for SQL-based systems.

Community
Intermediate
bs-koobs-koo

convert-ddl-to-tablespec

Convert CREATE TABLE DDL into DE-08 table definitions.

Community
Intermediate