Database Connections
Provides a unified TypeScript-based database server for seamlessly connecting to SQLite, PostgreSQL,...
Step-by-Step Instructions: Configuring ENV Values for MCP Database Server
Decide Your Database Type
Determine whether you will connect to SQLite, PostgreSQL, Microsoft SQL Server, or MongoDB. The environment variables you need depend on this choice.
Collect Your Database Connection Details
- For SQLite: Database file path.
- For PostgreSQL: Host, port, database name, user, and password.
- For SQL Server: Server address, port, database name, user, and password.
- For MongoDB: Connection URI and database name.
Fill in the Required ENV Values in the FastMCP Connection Interface
Click the "Install Now" button, and in the connection form, fill in the following ENV values for your selected database:
A. SQLite
MCP_SQLITE_FILENAME: Path to your SQLite database file (e.g.,/path/to/database.db)MCP_SQLITE_CREATE_IF_NOT_EXISTS: Usuallytrueif you want the file to be created if it doesn’t exist
B. PostgreSQL
MCP_POSTGRES_HOST: (e.g.,localhost)MCP_POSTGRES_PORT: (default is5432)MCP_POSTGRES_DATABASE: Your PostgreSQL database nameMCP_POSTGRES_USER: Your PostgreSQL usernameMCP_POSTGRES_PASSWORD: Your PostgreSQL passwordMCP_POSTGRES_SSL: Usuallyfalseunless your setup requires SSL
C. Microsoft SQL Server
MCP_MSSQL_SERVER: Your SQL Server address (e.g.,localhost)MCP_MSSQL_PORT: (default:1433)MCP_MSSQL_DATABASE: Your SQL Server database nameMCP_MSSQL_USER: Your SQL Server usernameMCP_MSSQL_PASSWORD: Your SQL Server passwordMCP_MSSQL_ENCRYPT: Oftentruefor secure connectionsMCP_MSSQL_TRUST_SERVER_CERTIFICATE: Oftentrue
D. MongoDB
MCP_MONGODB_URI: MongoDB connection string (e.g.,mongodb://localhost:27017)MCP_MONGODB_DATABASE: Your MongoDB database nameMCP_MONGODB_MAX_POOL_SIZE: (Optional, default:10)MCP_MONGODB_USE_UNIFIED_TOPOLOGY: (Optional, usuallytrue)
Complete the Setup
- After filling out the required ENV values, submit the form to finish installing the MCP Database Server integration.
- You can now use the tools (connect-database, execute-query, etc.) with your configured database.
Note: All required connection details must be obtained from your database administrator or from your hosting provider’s dashboard/connection info page. If you are running the database yourself locally, you likely have these credentials already. No API keys or third-party service tokens are needed—only standard database connection parameters.
Quick Start
Choose Connection Type for
Authentication Required
Please sign in to use FastMCP hosted connections
Configure Environment Variables for
Please provide values for the following environment variables:
started!
The MCP server should open in . If it doesn't open automatically, please check that you have the application installed.
Copy and run this command in your terminal:
Make sure Gemini CLI is installed:
Visit Gemini CLI documentation for installation instructions.
Make sure Claude Code is installed:
Visit Claude Code documentation for installation instructions.
Installation Steps:
Configuration
Installation Failed
More for Database
View All →Supabase MCP Server
Connect Supabase projects directly with AI assistants using the Model Context Protocol (MCP). This server standardizes communication between Large Language Models and Supabase, enabling AI to manage tables, query data, and interact with project features like edge functions, storage, and branching. Customize access with read-only or project-scoped modes and select specific tool groups to fit your needs. Integrated tools cover account management, documentation search, database operations, debugging, and more, empowering AI to assist with development, monitoring, and deployment tasks in your Supabase environment efficiently and securely.
ClickHouse
Unlock powerful analytics with the ClickHouse MCP Server—seamlessly run, explore, and manage SQL queries across ClickHouse clusters or with chDB’s embedded OLAP engine. This server offers easy database and table listing, safe query execution, and flexible access to data from files, URLs, or databases. Built-in health checks ensure reliability, while support for both ClickHouse and chDB enables robust data workflows for any project.
Remote
Postgres MCP Pro
Boost your Postgres database performance with Postgres MCP Pro, an AI-driven MCP server offering advanced index tuning, detailed explain plans, and comprehensive health checks. It combines proven optimization algorithms with schema intelligence for safe, context-aware SQL execution. Whether analyzing slow queries or recommending optimal indexes, Postgres MCP Pro empowers developers to improve efficiency and maintain database integrity. Designed for both development and production, it supports flexible transport options and robust access controls, making database management smarter, safer, and easier. Experience deterministic performance insights alongside AI assistance to keep your Postgres running at its best.
