Skip to main content
Glama

MCP PostgreSQL Server

by Maxim2324

MCP Server Test Collection

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

Deploy Server
A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

A server that connects to PostgreSQL databases and provides tools for safely exploring schemas, running read-only SQL queries, and performing data analysis with pre-built templates.

  1. Features
    1. Architecture
      1. Security Features
        1. Installation
          1. Configuration
            1. API Endpoints
              1. Schema Endpoints
              2. Query Endpoints
              3. Analysis Prompt Endpoints
            2. Example Queries
              1. Basic Table Query
              2. Using Analysis Prompts
            3. Development
              1. License

                Related MCP Servers

                • A
                  security
                  A
                  license
                  A
                  quality
                  Facilitates management and optimization of PostgreSQL databases, offering analysis, setup guidance, and debugging, while ensuring secure and efficient database operations.
                  Last updated -
                  3
                  1
                  16
                  AGPL 3.0
                  • Linux
                  • Apple
                • -
                  security
                  F
                  license
                  -
                  quality
                  Provides read-only access to PostgreSQL databases, enabling users to inspect database schemas and execute read-only queries through a Model Context Protocol server.
                  Last updated -
                  4
                • -
                  security
                  F
                  license
                  -
                  quality
                  A server that allows AI models to interact with PostgreSQL databases through a standardized protocol, providing database schema information and SQL query execution capabilities.
                  Last updated -
                  1
                • -
                  security
                  F
                  license
                  -
                  quality
                  Provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only SQL queries within a secure transaction context.
                  Last updated -
                  17,977
                  1
                  • Apple

                View all related MCP servers

                MCP directory API

                We provide all the information about MCP servers via our MCP API.

                curl -X GET 'https://glama.ai/api/mcp/v1/servers/Maxim2324/mcp-server-test'

                If you have feedback or need assistance with the MCP directory API, please join our Discord server