MCP Server for PostgreSQL

Build 25.0.9440

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.


PropertyDescription
AuthSchemeThe scheme used for authentication. If this property is left blank, the default authentication is used.
ServerThe host name or IP address of the server.
DatabaseThe name of the PostgreSQL database.
UserSpecifies the authenticating user's user ID.
PasswordSpecifies the authenticating user's password.
PortThe port number of the PostgreSQL server.
UseSSLThis property determines the configuration of SSL. When SSL is enabled, an encrypted connection is established between the user and the server, ensuring that data transmitted over the network remains secure and protected from interruption.
VisibilityFilters metadata for the user's permitted tables as a comma-separated list of queries. For example, to restrict visibility for SELECT and INSERT queries, specify 'SELECT,INSERT'. Permitted values: SELECT, INSERT, UPDATE, DELETE.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440