Connections

Database connections are the foundation of MCP Studio. Every SQL-backed tool and dynamic resource requires a connection to query data from.

​

Supported Databases

​

Creating a Connection

Navigate to Connections in the sidebar and click New Connection.

​

Form Fields

​

SSL Modes

For PostgreSQL connections:

• disable - No SSL
• allow - Try non-SSL first, then SSL
• prefer - Try SSL first, then non-SSL (default)
• require - Require SSL, skip CA verification
• verify-ca - Require SSL with CA verification
• verify-full - Require SSL with full hostname verification

​

Testing Connection Health

After filling in the connection form, click the Test Connection button to verify connectivity before saving. The test will:

1. Attempt to establish a connection using the provided credentials
2. Execute a lightweight health-check query
3. Report success or display the error message

​

Schema Explorer

Once a connection is saved and healthy, the schema explorer lets you browse the database structure:

• Tables - lists all tables in the connected database
• Columns - click a table to see its columns, data types, and nullability

This is useful when writing SQL queries for tools and resources.

​

Queue Settings

Each connection has individual queue settings to control concurrent query execution: See Queue Management for details.

​

Editing and Deleting

• Edit: Click a connection card to open it for editing. Modify any field and click Save.
• Delete: Click the delete icon. Connections bound to tools or resources cannot be deleted until those references are removed.

---

​

See Also