database-connectlisted
Install: claude install-skill manastalukdar/ai-devstudio
# Database Connection & Management
I'll help you connect to and manage databases through MCP servers for data exploration, schema inspection, and queries.
Arguments: `$ARGUMENTS` - database type (postgres, mysql, mongodb), connection details, or query
## Database Capabilities
**Supported Databases:**
- PostgreSQL (via MCP or native psql)
- MySQL/MariaDB (via MCP or native mysql)
- MongoDB (via MCP or native mongo)
- SQLite (local database files)
**Operations:**
- Schema inspection and exploration
- Safe query execution
- Data exploration and analysis
- Migration support
## Token Optimization
This skill uses database-specific patterns to minimize token usage:
### 1. Database Configuration Caching (700 token savings)
**Pattern:** Cache database connection details and configuration
- Store config in `.database-connection-cache` (1 hour TTL)
- Cache: DB type, connection string pattern, ORM tool, schema location
- Read cached config on subsequent runs (50 tokens vs 750 tokens fresh)
- Invalidate on config file changes (.env, schema.prisma, etc.)
- **Savings:** 93% on repeat connections
### 2. MCP Integration for Database Operations (1,500 token savings)
**Pattern:** Use MCP server for database interactions
- Connect via MCP database server (200 tokens)
- Execute queries through MCP (300 tokens)
- No Task agents for database operations
- Direct tool-to-database communication
- **Savings:** 83% vs LLM-mediated database operations
### 3. Bash-Based Schema Inspection (1,000