PineMCP (Multi-Database)
Provides unified access to 8 different database types (PostgreSQL, MySQL, SQLite, Redis, MongoDB, Cassandra, MSSQL, DynamoDB) through a single interface with 25+ management tools.
Provides unified database access across PostgreSQL, MySQL, SQLite, Redis, MongoDB, Cassandra, Microsoft SQL Server, and Amazon DynamoDB with 25+ tools for operations, schema management, data export/import, query performance analysis, and transaction support through a comprehensive adapter pattern architecture.
What it does
- Query multiple database types with unified syntax
- Export and import data in JSON, CSV, SQL, XML formats
- Generate DDL and migration scaffolding
- Analyze query performance and execution
- Compare database schemas across systems
- Manage transactions with rollback support
Best for
About PineMCP (Multi-Database)
PineMCP (Multi-Database) is a community-built MCP server published by zyleree that provides AI assistants with tools and capabilities via the Model Context Protocol. PineMCP (Multi-Database): unified access to PostgreSQL, MySQL, Redis, and more. 25+ tools for operations, queries, and s It is categorized under databases, developer tools.
How to install
You can install PineMCP (Multi-Database) in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.
License
PineMCP (Multi-Database) is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.
PineMCP v2.1.2
PineMCP is a professional Model Context Protocol (MCP) server that provides a unified, safe interface to multiple database types. It ships with robust connection management, schema tooling, data import/export, and query analysis — all exposed as MCP tools over stdio.
🚀 New in v2.1.2:
- 🔒 Security Fix: Resolved tar-fs symlink validation bypass vulnerability (CVE-2025-59343)
- ✅ Dependency Updates: Updated tar-fs to patched version 2.1.4
- ✅ Enhanced Security: Added package overrides to prevent future vulnerabilities
Previous v2.1.0 Features:
- ✅ Fixed Critical Bugs: All database adapters now work correctly
- ✅ Enhanced Error Handling: Structured error system with proper context
- ✅ Improved Type Safety: Eliminated unsafe type assertions
- ✅ Better Security: Enhanced NoSQL injection protection
- ✅ MCP Integration: Seamless configuration loading from MCP JSON files
—
Why PineMCP?
- Unified access to PostgreSQL, MySQL, SQLite, Redis, MongoDB, Cassandra, MSSQL, and DynamoDB
- Safe query execution with guardrails and transaction support
- Schema comparison, DDL generation, and migration scaffolding
- Data export/import (JSON, CSV, SQL, XML)
- Query analysis with heuristics, history, and templates
- Production-ready with comprehensive error handling and security measures
—
Quick Start
-
Installation and environment setup: see the Installation Guide
-
Configure databases in your MCP client (no local setup step). See MCP Integration for client-specific instructions and examples.
—
Documentation
—
CLI Overview
PineMCP exposes a CLI via the pinemcp binary. For a complete list of commands and options, see the Installation Guide. Common tasks:
pinemcp start
pinemcp test-connection --name <connectionName>
Note: PineMCP 2.0.0 does not persist configuration. Connections are supplied by your MCP client. Only the data/ directory is used to store history/templates; mount it in Docker if you want persistence.
—
Deployment
See detailed instructions in the Installation Guide:
—
License
PineMCP is released under the MIT License. See LICENSE.
Alternatives
Related Skills
Browse all skillsUI design system toolkit for Senior UI Designer including design token generation, component documentation, responsive design calculations, and developer handoff tools. Use for creating design systems, maintaining visual consistency, and facilitating design-dev collaboration.
Modern web development expertise covering React, Node.js, databases, and full-stack architecture. Use when: building web applications, developing APIs, creating frontends, setting up databases, deploying web apps, or when user mentions React, Next.js, Express, REST API, GraphQL, MongoDB, PostgreSQL, or full-stack development.
Find, connect, and use MCP tools and skills via the Smithery CLI. Use when the user searches for new tools or skills, wants to discover integrations, connect to an MCP, install a skill, or wants to interact with an external service (email, Slack, Discord, GitHub, Jira, Notion, databases, cloud APIs, monitoring, etc.).
Answer questions about the AI SDK and help build AI-powered features. Use when developers: (1) Ask about AI SDK functions like generateText, streamText, ToolLoopAgent, embed, or tools, (2) Want to build AI agents, chatbots, RAG systems, or text generation features, (3) Have questions about AI providers (OpenAI, Anthropic, Google, etc.), streaming, tool calling, structured output, or embeddings, (4) Use React hooks like useChat or useCompletion. Triggers on: "AI SDK", "Vercel AI SDK", "generateText", "streamText", "add AI to my app", "build an agent", "tool calling", "structured output", "useChat".
Master API documentation with OpenAPI 3.1, AI-powered tools, and modern developer experience practices. Create interactive docs, generate SDKs, and build comprehensive developer portals. Use PROACTIVELY for API documentation or developer portal creation.
Use when working with the OpenAI API (Responses API) or OpenAI platform features (tools, streaming, Realtime API, auth, models, rate limits, MCP) and you need authoritative, up-to-date documentation (schemas, examples, limits, edge cases). Prefer the OpenAI Developer Documentation MCP server tools when available; otherwise guide the user to enable `openaiDeveloperDocs`.