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.
주요 기능
01Search for columns across all tables by name.
02Count rows with optional WHERE clause filtering.
031 GitHub stars
04Fetch sample data rows from any specified table.
05List all available tables and retrieve detailed schema information (columns, keys).
06Execute read-only SELECT queries on PostgreSQL databases.
