Db Explorer
Connect to and explore databases (PostgreSQL, MySQL, SQLite, MongoDB, Redis). Run queries, inspect schemas, export data. Use when user wants to query a datab... Skill: Db Explorer Owner: lrg913427-dot Summary: Connect to and explore databases (PostgreSQL, MySQL, SQLite, MongoDB, Redis). Run queries, inspect schemas, export data. Use when user wants to query a datab... Tags: latest:3.0.0 Version history: v3.0.0 | 2026-06-04T04:06:03.636Z | auto - Removed the skill-card.md file. - No other functional or documentation changes noted. v2.6.0 | 2026-06-03T16:05:30.806Z | auto - Up
Rank
62
Safety
84
Downloads
1.4k
Updated
Oct 10, 2026
Version
3.0.0
Source
CLAWHUB
About
What it does, and when to use it.
Capability contract not published. No trust telemetry is available yet. 1.4K downloads reported by the source. Last updated 10/10/2026.
Avoid when
- Contract metadata is missing or unavailable for deterministic execution.
Risk flags: missing_or_unavailable_contract, trust_data_unavailable, schema_references_missing
Public facts
Every fact links back to the source it came from.
- Vendor
- Clawhubvendor · observed Oct 10, 2026
- Protocol compatibility
- OpenClawcompatibility · observed Oct 10, 2026
- Adoption signal
- 1.4K downloadsadoption · observed Oct 10, 2026
- Latest release
- 3.0.0release · observed Jun 4, 2026
- Handshake status
- UNKNOWNsecurity
Install and run
Setup complexity: low.
clawhub skill install s175nn6ap9fe4ne23bws9svzm185ywrq:db-explorer-lrg- Setup complexity is classified as HIGH. You must provision dedicated cloud infrastructure or an isolated VM. Do not run this directly on your local workstation.
- Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.
Contract: missing
curl -s "https://www.xpersona.co/api/v1/agents/clawhub-lrg913427-dot-db-explorer-lrg/snapshot"
Documentation
CLAWHUB
115,150 characters of source documentation, loaded on request.
Extracted files
3 files captured from the source.
SKILL.md
---
name: db-explorer
description: "Connect to and explore databases (PostgreSQL, MySQL, SQLite, MongoDB, Redis). Run queries, inspect schemas, export data. Use when user wants to query a database, explore schema, check data, export results, or debug database issues."
version: 2.5.0
author: lrg913427-dot
license: MIT
metadata:
hermes:
tags: [database, sql, postgresql, mysql, sqlite, mongodb, redis, query, schema, data]
related_skills: [jupyter-live-kernel, airtable]
---
# DB Explorer
Connect to databases, run queries, explore schemas, and export data — all from the terminal.
## When to Use
Activate this skill when the user:
- Says "check the database", "query the DB", "show me the data"
- Wants to see table structure, row counts, or sample data
- Needs to export data to CSV/JSON
- Wants to find slow queries or check DB health
- Mentions a database connection string or DB name
## Supported Databases
| Database | CLI Tool | Install (macOS) | Install (Linux) |
|-----------|-------------|---------------------------|-----------------------------------|
| PostgreSQL | psql | brew install postgresql | apt install postgresql-client |
| MySQL | mysql | brew install mysql | apt install mysql-client |
| SQLite | sqlite3 | (built-in on macOS) | apt install sqlite3 |
| MongoDB | mongosh | brew install mongosh | See mongodb.com/docs/shell |
| Redis | redis-cli | brew install redis | apt install redis-tools |
## Quick Start
### 1. Identify the Database
Ask the user for:
- Database type (postgres/mysql/sqlite/mongo/redis)
- Connection string OR host/port/database/user/password
- For SQLite: just the file path
### 2. Connect and Explore
```bash
# PostgreSQL
psql "postgresql://user:password@host:5432/dbname" -c "\dt" # list tables
psql "postgresql://user:password@host:5432/dbname" -c "\d table_name" # describe table
psql "postgresql://user:password@host:5432/dbname" -c "SELECT count(*) FROM table_name;"
# MySQL
mysql -h host -u user -p dbname -e "SHOW TABLES;"
mysql -h host -u user -p dbname -e "DESCRIBE table_name;"
mysql -h host -u user -p dbname -e "SELECT count(*) FROM table_name;"
# SQLite
sqlite3 /path/to/db.db ".tables" # list tables
sqlite3 /path/to/db.db ".schema table_name" # describe table
sqlite3 /path/to/db.db "SELECT count(*) FROM table_name;"
# MongoDB
mongosh "mongodb://user:password@host:27017/dbname" --eval "db.getCollectionNames()"
mongosh "mongodb://user:password@host:27017/dbname" --eval "db.collection_name.countDocuments()"
# Redis
redis-cli -h host -p 6379 -a password INFO keyspace
redis-cli -h host -p 6379 -a password DBSIZE
redis-cli -h host -p 6379 -a password KEYS "*"
```
### 3. Safety Rules
**ALWAYS follow these rules:**
1. **Read-only by default** — Never run INSERT/UPDATE/DELETE/DROP without explicit user confirmation
_meta.json
{
"ownerId": "kn78qy8qw1m82vx09qkaawp9c985z0mn",
"slug": "db-explorer-lrg",
"version": "3.0.0",
"publishedAt": 1780545963636
}skill-card.md
## Description: Connect to and explore databases (PostgreSQL, MySQL, SQLite, MongoDB, Redis), run queries, inspect schemas, export data, and debug database issues. This skill is ready for commercial/non-commercial use. ## Publisher: [lrg913427-dot](https://clawhub.ai/user/lrg913427-dot) ### License/Terms of Use: MIT-0 ## Use Case: Developers and engineers use this skill to inspect database schemas, run bounded queries, diagnose database health, and export or migrate data across PostgreSQL, MySQL, SQLite, MongoDB, and Redis. ### Deployment Geography for Use: Global ## Known Risks and Mitigations: Risk: Database export, restore, import, and migration commands can expose or alter data if copied directly. Mitigation: Use least-privileged, non-production credentials where possible, confirm the exact target database before running data-changing commands, and review generated commands before execution. Risk: Credentials may be exposed when passwords are pasted into command lines or shared output locations. Mitigation: Prefer environment variables or private secret handling for credentials, avoid echoing real passwords, and write exports to private, access-controlled locations instead of shared temporary paths. ## Reference(s): - [ClawHub Skill Page](https://clawhub.ai/lrg913427-dot/skills/db-explorer-lrg) - [ClawHub Publisher Profile](https://clawhub.ai/user/lrg913427-dot) - [MongoDB Shell Documentation](https://www.mongodb.com/docs/shell) ## Skill Output: **Output Type(s):** [text, markdown, shell commands, configuration, guidance] **Output Format:** [Markdown with inline shell commands and query snippets] **Output Parameters:** [1D] **Other Properties Related to Output:** [May include database CLI commands, SQL or shell snippets, schema summaries, export guidance, and safety checks.] ## Skill Version(s): 3.0.0 (source: server release metadata) ## Ethical Considerations: Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.
AionUi
Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!
activepieces
AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
cherry-studio
AI productivity studio with smart chat, autonomous agents, and 300+ assistants.
CopilotKit
The Frontend for Agents & Generative UI. React + Angular
Machine-readable data
The same record, as JSON, for agents and crawlers.
{
"facts": [
{
"factKey": "vendor",
"category": "vendor",
"label": "Vendor",
"value": "Clawhub",
"href": "https://clawhub.ai/lrg913427-dot/skills/db-explorer-lrg",
"sourceUrl": "https://clawhub.ai/lrg913427-dot/skills/db-explorer-lrg",
"sourceType": "profile",
"confidence": "medium",
"observedAt": "2026-10-10T13:04:05.255Z",
"isPublic": true
},
{
"factKey": "protocols",
"category": "compatibility",
"label": "Protocol compatibility",
"value": "OpenClaw",
"href": "https://www.xpersona.co/api/v1/agents/clawhub-lrg913427-dot-db-explorer-lrg/contract",
"sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-lrg913427-dot-db-explorer-lrg/contract",
"sourceType": "contract",
"confidence": "medium",
"observedAt": "2026-10-10T13:04:05.255Z",
"isPublic": true
},
{
"factKey": "traction",
"category": "adoption",
"label": "Adoption signal",
"value": "1.4K downloads",
"href": "https://clawhub.ai/lrg913427-dot/db-explorer-lrg",
"sourceUrl": "https://clawhub.ai/lrg913427-dot/db-explorer-lrg",
"sourceType": "profile",
"confidence": "medium",
"observedAt": "2026-10-10T13:04:05.255Z",
"isPublic": true
},
{
"factKey": "latest_release",
"category": "release",
"label": "Latest release",
"value": "3.0.0",
"href": "https://clawhub.ai/lrg913427-dot/db-explorer-lrg",
"sourceUrl": "https://clawhub.ai/lrg913427-dot/db-explorer-lrg",
"sourceType": "release",
"confidence": "medium",
"observedAt": "2026-06-04T04:06:03.636Z",
"isPublic": true
},
{
"factKey": "handshake_status",
"category": "security",
"label": "Handshake status",
"value": "UNKNOWN",
"href": "https://www.xpersona.co/api/v1/agents/clawhub-lrg913427-dot-db-explorer-lrg/trust",
"sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-lrg913427-dot-db-explorer-lrg/trust",
"sourceType": "trust",
"confidence": "medium",
"observedAt": null,
"isPublic": true
}
],
"events": [
{
"eventType": "release",
"title": "Release 3.0.0",
"description": "- Removed the skill-card.md file. - No other functional or documentation changes noted.",
"href": "https://clawhub.ai/lrg913427-dot/db-explorer-lrg",
"sourceUrl": "https://clawhub.ai/lrg913427-dot/db-explorer-lrg",
"sourceType": "release",
"confidence": "medium",
"observedAt": "2026-06-04T04:06:03.636Z",
"isPublic": true
}
]
}Record generated Oct 10, 2026.
