Avanti Fellows PostgreSQL

概要

This tool functions as an MCP (Model Context Protocol) server, specifically engineered to connect AI assistants like Claude Code and Cursor directly with the Avanti Fellows PostgreSQL database. Designed with a strong emphasis on security, it strictly enforces read-only operations, preventing any modifications such as INSERT, UPDATE, or DELETE, thereby safeguarding data integrity. It offers a suite of functionalities for database exploration, enabling AI to list tables, describe schemas, retrieve sample data, count rows with specific conditions, and execute custom SELECT queries, significantly streamlining data analysis and retrieval for AI-powered workflows.

主な機能

• Search for columns across all tables by name.
• Count rows with optional WHERE clause filtering.
• 1 GitHub stars
• Fetch sample data rows from any specified table.
• List all available tables and retrieve detailed schema information (columns, keys).
• Execute read-only SELECT queries on PostgreSQL databases.

ユースケース

• Enabling AI assistants to perform database introspection and schema discovery.
• Facilitating AI-driven data exploration and retrieval for analytical purposes.
• Allowing AI to answer data-related questions directly from the database.