How does the skill ensure data safety?

It requires explicit user confirmation for all data-modifying operations and enforces schema exploration before any queries can be executed to prevent errors.

Can it help me install missing database CLI tools?

Yes, the skill detects your operating system and can automate the installation of mysql-client, psql, sqlite3, or redis-cli via Homebrew, APT, or Pacman.

Is there a limit on query results?

By default, the skill adds a LIMIT 100 clause to SELECT queries to prevent performance issues and terminal clutter, though this can be overridden by the user.

How are database credentials handled?

The skill never uses environment variables without permission. It asks you to provide credentials manually or read them from a local configuration file like a .env or docker-compose file.

Does this skill support Redis?

Yes, it supports Redis key-value operations and data structure management (lists, sets, hashes) alongside standard SQL databases.

Database CLI Assistant

Name: Database CLI Assistant
Author: husniadil

byhusniadil

•

Database Management

Manages and queries MySQL, PostgreSQL, SQLite, and Redis databases through Claude Code with mandatory schema discovery and safety guardrails.

The Database CLI Assistant provides a robust interface for Claude to interact with various database engines using their native command-line tools. It eliminates guesswork by enforcing a strict workflow that requires exploring tables and column structures before executing any data queries. This skill is ideal for developers needing to inspect live data, verify schemas, or perform administrative tasks while maintaining high safety standards. It includes built-in protections against destructive operations, credential security protocols, and intelligent detection of database types from environment variables or connection strings.

Key Features

01Automated CLI installation assistance for macOS, Linux, and Arch

021 GitHub stars

03Support for MySQL, PostgreSQL, SQLite, and Redis via native CLI tools

04Strict confirmation workflow for all INSERT, UPDATE, and DELETE operations

05Contextual database type detection from configs, ports, and file extensions

06Mandatory schema exploration to prevent incorrect table or column assumptions

Use Cases

01Executing safe data lookups and administrative updates without leaving the terminal

02Verifying data integrity and record counts across multiple database environments

03Exploring and documenting unfamiliar database schemas during onboarding or debugging

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add husniadil/ekstend database

For use in Claude.ai and ChatGPT

Download Skill