AgriDatabase-MCP-Server
Verified Safeby shayrylmae
Overview
Provides secure, read-only database access to an Agri-Geo Supabase database for AI assistants via the Model Context Protocol (MCP).
Installation
npm run devEnvironment Variables
- SUPABASE_URL
- SUPABASE_ANON_KEY
- PORT
- NODE_ENV
Security Notes
The server uses Supabase client for database interactions, ensuring parameterized queries and preventing SQL injection. All tool arguments are validated using Zod schemas. It is designed for read-only access, with no INSERT/UPDATE/DELETE operations implemented. Environment variables are loaded via dotenv, preventing hardcoded secrets. Error handling appears to be safe, avoiding database schema leaks. No use of dangerous functions like 'eval' or direct child_process execution is observed. The SSE transport implements a connection registry with cleanup for stale sessions. The only minor point is the default permissive CORS for SSE ('Access-Control-Allow-Origin', '*') which should be restricted in production, as noted in the DEPLOYMENT.md.
Similar Servers
pb_mcp_server
Provides an MCP interface for AI assistants to interact with PocketBase databases for data management, authentication, and administrative tasks.
greptimedb-mcp-server
Enables AI assistants to query and analyze GreptimeDB, an open-source, cloud-native, unified observability database, using SQL, TQL, and RANGE queries, with built-in security and data masking.
vcon-mcp
The vCon MCP Server stores, manages, and provides advanced search and AI/ML analysis capabilities for IETF vCon (Virtual Conversation) objects, supporting multi-tenancy and extensibility via plugins.
mcp
Execute MySQL, Redis, ClickHouse, SQLite, and Prometheus database commands and queries through a natural language AI assistant, including support for SSH tunneling.