skills.rest
manastalukdar
manastalukdarCOMMUNITY
Explore all skills by this author →
Website𝕏@manastalukdarGitHub

database-connect

Inspect schemas and execute queries across PostgreSQL, MySQL, and MongoDB.

1|Updated Jan 26, 2026
Search Tags:#database#schema#migration#sql#query#mongodb
One-click install
npx skills add https://github.com/manastalukdar/claude-devstudio --skill database-connect
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-connect
Source: https://github.com/manastalukdar/claude-devstudio/tree/main/skills/database-connect
Command: npx skills add https://github.com/manastalukdar/claude-devstudio --skill database-connect

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pg, mysql2, mongodb, prisma, knex, typeorm, alembic, django, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies connecting to and managing various databases (PostgreSQL, MySQL, MongoDB, SQLite) by leveraging MCP servers and native CLI tools, reducing the complexity of data exploration and query execution.

Core Features & Use Cases

  • Multi-database Support: Connects to PostgreSQL, MySQL, MongoDB, and SQLite.
  • Schema Inspection: Safely explores database schemas, tables, indexes, and relationships.
  • Query Execution: Executes SQL and MongoDB queries with safety features like read-only mode and timeouts.
  • Migration Assistance: Supports running database migrations for various ORMs and tools.
  • Use Case: You need to quickly inspect the schema of a PostgreSQL database, run a few read-only queries to understand user data, and then apply pending database migrations.

Quick Start

Use the database-connect skill to inspect the schema of the PostgreSQL database using the provided connection string.

Frequently Asked Questions about database-connect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I inspect a PostgreSQL database schema and run read-only queries?▼

You can inspect your PostgreSQL database schema and execute read-only queries by using MCP server integration, which safely explores tables and relationships while enforcing timeouts to prevent unintended modifications.

Can I run database migrations for Prisma, Knex, or TypeORM?▼

Yes, you can run database migrations for Prisma, Knex, and TypeORM. The Skill provides migration management through native CLI tools, allowing you to apply pending schema changes efficiently across your supported databases.

What is the best way to manage both SQL and MongoDB connections in a single workflow?▼

The best way to manage SQL and MongoDB connections in a single workflow is using a unified interface that leverages MCP servers and native CLI tools. This approach simplifies connecting to PostgreSQL, MySQL, and MongoDB, reducing data exploration complexity.

Does this database connection tool support MySQL and SQLite?▼

Yes, this database connection tool supports MySQL and SQLite. It facilitates secure and efficient database operations across PostgreSQL, MySQL, MongoDB, and SQLite, enabling structured data access and manipulation within your development workflows.

How do I execute safe SQL queries with timeouts to prevent locking issues?▼

You can execute safe SQL queries with timeouts by utilizing the built-in query execution safety features. This functionality supports read-only modes and enforces execution timeouts, ensuring secure data manipulation without locking issues.

Why use MCP server integration for database schema inspection instead of direct CLI access?▼

Using MCP server integration for database schema inspection provides structured, secure data access compared to direct CLI access. It safely explores schemas, tables, and relationships while maintaining safe query execution boundaries within your development workflows.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
porcupine-mdporcupine-md
11

migration

Detect ORMs, update schemas, generate migrations, and validate changes.

Official
Advanced
zero3041zero3041
1

database-migrations

Guide database migrations across PostgreSQL, MySQL, and ORMs.

Community
Advanced
contatomayconcontatomaycon

drizzle-orm

Build type-safe SQL data-access layers with compile-time query inference.

Community
Advanced