IBM Netezza
Connect to IBM Netezza Performance Server to execute SQL and view table metadata.
Key Features
- IBM Netezza database connection
- SQL query execution
- List tables and views
- View column information for tables or views
- Read-only mode support
- Private network connection support through Edge Tunnel
Basic Information
Authentication Method
Authenticate using username/password.
Input Parameters
- Host (required): Netezza host address
- Port (required): Netezza port number. The default is
5480. - Database Name (optional): Database name to connect to. The default is
SYSTEM. - Username (required): Netezza username
- Password (required): Netezza password
- Read Only (optional): Whether to allow only read-only SQL. Enabled by default.
Supported MCP Tools
execute_sql
Executes a SQL query on the IBM Netezza database and returns the result. When read-only mode is enabled, data-changing queries can be restricted.
list_tables
Lists Netezza tables. You can adjust whether to include views and system catalogs as needed.
describe_table
Retrieves column information for the specified table or view.
IBM Netezza Connection Setup
- Prepare a user account that can access Netezza.
- Grant the required permissions for the database and schema to query.
- Select the IBM Netezza Integration.
- Enter Host, Port, Database Name, Username, and Password.
- If you need to connect to Netezza in a private or local network, enable Edge Tunnel.
- If you will use it in read-only mode, save it with Read Only enabled.
Usage Examples
- “Show me the customer table list in Netezza”
- “Describe the columns of the
ORDERStable in theSALESschema” - “Run SQL to count last month’s orders”
Notes
- When connecting to a production database, use an account with only the minimum required permissions.
- To connect to a private IP, local address, or internal network host, check the Edge Tunnel connection status first.
- If read-only mode is disabled, data-changing SQL may be executed, so review permissions and purpose before use.
Last updated on