amazon-q-postgresql-mcp-server

amazon-q-postgresql-mcp-server

0
databases

This project is a Rust-based server that implements the MCP protocol, enabling integration with Amazon Q to interact with PostgreSQL databases. It allows for performing read-only operations such as listing tables, retrieving table schemas, and executing SQL queries with results returned in JSON format.

Overview

A Rust-based MCP server facilitating PostgreSQL database interactions through the Amazon Q interface.

Features

  • List tables in PostgreSQL databases.
  • Retrieve schema information for specific tables.
  • Execute read-only SQL queries with results in JSON format.

Prerequisites

  • Rust 1.70
  • Cargo package manager
  • PostgreSQL database
  • Amazon Q CLI

Installation

  1. Clone the repository.
  2. Build the project using Cargo.

Usage

  • Requires PostgreSQL connection string for running the server.
  • Integrate with Amazon Q CLI for database operations.
  • Use for listing tables, getting schema, and executing SQL queries.