# PostgreSQL and MySQL

> Use this tool when you need to unify database connectivity for PostgreSQL and MySQL, solving problems in database administration, data analysis, and application development. It provides a flexible interface for secure and performant database interactions, accepting environment variables and direct parameters as input and outputting query results and schema information. Use it in contexts where multiple database configurations and seamless integration are required.

Canonical page: https://skillsregistry.net/skills/tranchihuu-postgres-mysql  
JSON: https://api.skillsregistry.net/v1/skills/tranchihuu-postgres-mysql

## Description

Provides unified database connectivity for PostgreSQL and MySQL through a flexible interface supporting both environment variables and direct parameters. Features connection pooling for performance optimization, parameterized queries for security, and schema introspection with automatic SSL support. Supports multiple configuration approaches including generic DB_ variables or database-specific environment variables, enabling seamless integration into existing workflows. Useful for database administration, data analysis, schema exploration, and building database-driven applications.

## Trust

- **Trust score (0–1):** 0.98
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-19

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/tranchihuu-postgres-mysql)
- **Repository:** <https://github.com/tranchihuu/postgres-mysql-mcp-server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "tranchihuu-postgres-mysql"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/tranchihuu-postgres-mysql` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/tranchihuu-postgres-mysql/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt