Author avatar

aws-sample-gen-ai-mcp-server

by jikang-jeong

Server

Tags

4.8 (120)

This sample code project is a fork from [https://github.com/aws-samples/Sample-Model-Context-Protocol-Demos]'s repository.

  • add postgres db-conn sample
  • add web search (wikipedia) sample

✅ Prerequisites

  • Python 3.13+
  • PostgreSQL (via Docker)

Start PostgreSQL with Docker Compose

  docker-compose -f docker-compose/docker-compose.yml up -d

Initialize the Database

  • SQL initialization script: /init/init.sql
    (Includes both DDL and DML)

⚡ Quick Start

  1. Set up a virtual environment (recommended):
  python -m venv venv
  source venv/bin/activate  # On Windows: venv\Scripts\activate
  1. Install dependencies:
  pip install -r init/requirements.txt
  1. Run
  python3 main.py

🐘 PostgreSQL Driver Issue (psycopg)

만약, 아래 오류가 출력된다면

ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found

아래 PostgreSQL client libraries 설치하십시오. 또는 postgres 모듈을 변경 사용해도 됩니다.

macOS:

  brew install libpq
  brew link --force libpq

Ubuntu:

  sudo apt-get install libpq-dev

Related Services

playwright-mcp

Server

4.8 (120)
View Details →

blender-mcp

Server

4.8 (120)
View Details →

tavily-mcp

Server

4.8 (120)
View Details →