This repository contains a collection of tests and implementations for various Model-Controller-Provider (MCP) server architectures. Each implementation focuses on different aspects of MCP pattern and database interactions.
Current Implementations
1. MCP PostgreSQL Server (mcp-psql/)
A PostgreSQL-specific implementation that:
- Provides safe database access through a structured API
- Enables AI systems to interact with databases
- Implements read-only query validation
- Includes pre-built analysis templates
- Supports schema exploration and data analysis
2. MCP Figma Server (mcp-figma/)
A Figma-specific implementation that:
- Enables AI systems to interact with Figma designs
- Provides structured access to Figma files and components
- Implements design analysis and manipulation capabilities
- Supports AI-driven design suggestions and modifications
- Includes pre-built design templates and patterns
Purpose
This repository serves as:
- A testing ground for different MCP implementations
- A reference for MCP pattern best practices
- A collection of database and design tool interaction patterns
- A showcase of AI integration approaches with various systems
Getting Started
Each implementation in this collection has its own setup instructions and documentation. Please refer to the specific implementation's README for details.
Contributing
New MCP implementations and test cases are welcome! Please follow these guidelines:
1. Create a new directory for your implementation
2. Include comprehensive documentation
3. Follow the existing project structure
4. Add appropriate tests
License
MIT
[
{
"description": "Connect to PostgreSQL database. NOTE: Default connection exists - only use when requested or if other commands fail",
"inputSchema": {
"properties": {
"database": {
"description": "Database name",
"type": "string"
},
"host": {
"description": "Database host",
"type": "string"
},
"password": {
"description": "Database password",
"type": "string"
},
"port": {
"description": "Database port (default: 5432)",
"type": "number"
},
"user": {
"description": "Database user",
"type": "string"
}
},
"required": [
"host",
"user",
"password",
"database"
],
"type": "object"
},
"name": "connect_db"
},
{
"description": "Execute a SELECT query",
"inputSchema": {
"properties": {
"params": {
"description": "Query parameters (optional)",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
},
"type": "array"
},
"sql": {
"description": "SQL SELECT query (use $1, $2, etc. for parameters)",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
},
"name": "query"
},
{
"description": "Execute an INSERT, UPDATE, or DELETE query",
"inputSchema": {
"properties": {
"params": {
"description": "Query parameters (optional)",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
},
"type": "array"
},
"sql": {
"description": "SQL query (INSERT, UPDATE, DELETE) (use $1, $2, etc. for parameters)",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
},
"name": "execute"
},
{
"description": "List all tables in the database",
"inputSchema": {
"properties": {},
"required": [],
"type": "object"
},
"name": "list_tables"
},
{
"description": "Get table structure",
"inputSchema": {
"properties": {
"table": {
"description": "Table name",
"type": "string"
}
},
"required": [
"table"
],
"type": "object"
},
"name": "describe_table"
}
]