Skip to content

PostgreSQL

Updated View as Markdown

Create a dedicated read-only database user in the provider console or database administration client; copy its public host, port, database, username and password into the Tooluse.net connection. Allow the deployment egress address in the provider firewall and require TLS with a valid hostname certificate; optionally add its CA PEM. No provider API key is used. Only fixed metadata queries and selected-column previews are available; no arbitrary SQL or writes. Previews return bounded text (256 characters per cell), at most 100 rows, without stable ordering guarantees. This is an independently authored inspection subset. One bounded native operation per invocation, no retries or automatic pagination. Public addresses only; connection timeout and output limits apply.

What you can do (4)

What you can do

Available commands: 4 (4 read, 0 write). Enable only the commands your application needs.

Command Effect
List accessible schemas — postgresql.schemas.list Read
List schema tables — postgresql.tables.list Read
List table columns — postgresql.columns.list Read
Preview selected columns (text, 256 characters per cell) — postgresql.rows.preview Read

Connect and use

Connect and use

Open the integration's connection form to check the available credential source. The source has not been resolved for this documentation export. The instructions below apply when using your own provider account.

Get your provider credentials

Follow these steps for PostgreSQL, then enter the issued values in the connection form below.

  1. Create a dedicated read-only database user in the provider console or database administration client; copy its public host, port, database, username and password into the Tooluse.net connection. Allow the deployment egress address in the provider firewall and require TLS with a valid hostname certificate; optionally add its CA PEM. No provider API key is used. Only fixed metadata queries and selected-column previews are available; no arbitrary SQL or writes. Previews return bounded text (256 characters per cell), at most 100 rows, without stable ordering guarantees. This is an independently authored inspection subset. One bounded native operation per invocation, no retries or automatic pagination. Public addresses only; connection timeout and output limits apply.

Official credential setup

Where to enter credentials

In the integration page, sign in, choose your workspace and open Connect. If a Credentials choice is shown, select Use my credentials. Fill the following connection fields and save. Provider credentials belong in this form, never in an MCP configuration or tool input.

Connection field Requirement
Public hostname Required
Port Optional
Username Required
Database Required
Password Required
Optional trusted CA (PEM) Optional

Open API keys and create a Tooluse.net key for the enabled commands.

Set TOOLUSE_API_KEY in your client and use the shared MCP configuration.

Configure Claude Code, Codex or Cursor once

Permissions and results

If you have more than one workspace, check the selected workspace in the connection or API-key dialog before saving. Roles, enabled commands, expiry and revocation use Tooluse.net's existing permissions. Disabling a connection or revoking a key immediately prevents new calls.

Send one Claude tool_use block per request. Keep the same Idempotency-Key when retrying the same request; use a new key for a new call. The response includes the shared Tooluse.net receipt and Claude tool_result. Check both HTTP status and the returned tool result before treating a call as successful.

Your connection's daily allowance and key permissions also apply. Adding a connection does not make a provider request.

Calls return the shared execution receipt and a Claude tool_result. Provider output varies by operation; consult the provider documentation for its response fields. Unconfirmed calls should be checked before retrying.

Call from your client

Use the shared MCP configuration. Refresh your client's tool list after saving the connection or changing key permissions, then call the returned tool name with the example input below.

Configure Claude Code, Codex or Cursor once

Discover your enabled tools

List permitted tools in Claude format. Read every page using page and size (maximum 100) until all results have been received. Use the returned name, not a catalog capability identifier, in the tool_use block.

curl 'https://api.tooluse.net/v1/tools' \
  -H "Authorization: Bearer $TOOLUSE_API_KEY"

Find this command in the tool list permitted by your key. Replace svc_FROM_YOUR_TOOL_LIST with its returned name. Use a new Idempotency-Key for each new call and retain it when retrying that same call.

HTTP call

curl 'https://api.tooluse.net/v1/tool-calls' \
  -H "Authorization: Bearer $TOOLUSE_API_KEY" \
  -H 'Content-Type: application/json' \
  -H 'Idempotency-Key: replace-with-a-new-call-id' \
  --data '{
  "type": "tool_use",
  "id": "toolu_example",
  "name": "svc_FROM_YOUR_TOOL_LIST",
  "input": {}
}'

Send one Claude tool_use block per request. Keep the same Idempotency-Key when retrying the same request; use a new key for a new call. The response includes the shared Tooluse.net receipt and Claude tool_result. Check both HTTP status and the returned tool result before treating a call as successful.

Commands

List accessible schemas — postgresql.schemas.list

Run List accessible schemas with PostgreSQL. This is a read command; it does not grant access beyond the connected account's permissions.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

This tool has no input parameters.

Full JSON Schema

Full JSON Schema

Example input

{}

At most 1 provider requests per invocation; timeout: 15 seconds.

List schema tables — postgresql.tables.list

Run List schema tables with PostgreSQL. This is a read command; it does not grant access beyond the connected account's permissions.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
schema string Required maxLength: 63; pattern: "^[_A-Za-z][_A-Za-z0-9]{0,62}$"

Full JSON Schema

Full JSON Schema

Example input

{
  "schema": "public"
}

At most 1 provider requests per invocation; timeout: 15 seconds.

List table columns — postgresql.columns.list

Run List table columns with PostgreSQL. This is a read command; it does not grant access beyond the connected account's permissions.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
schema string Required maxLength: 63; pattern: "^[_A-Za-z][_A-Za-z0-9]{0,62}$"
table string Required maxLength: 63; pattern: "^[_A-Za-z][_A-Za-z0-9]{0,62}$"

Full JSON Schema

Full JSON Schema

Example input

{
  "schema": "public",
  "table": "items"
}

At most 1 provider requests per invocation; timeout: 15 seconds.

Preview selected columns (text, 256 characters per cell) — postgresql.rows.preview

Run Preview selected columns (text, 256 characters per cell) with PostgreSQL. This is a read command; it does not grant access beyond the connected account's permissions.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
schema string Required maxLength: 63; pattern: "^[_A-Za-z][_A-Za-z0-9]{0,62}$"
table string Required maxLength: 63; pattern: "^[_A-Za-z][_A-Za-z0-9]{0,62}$"
columns array Required minItems: 1; maxItems: 10; uniqueItems: true
columns[] string Optional maxLength: 63; pattern: "^[_A-Za-z][_A-Za-z0-9]{0,62}$"
limit integer Optional default: 10; minimum: 1; maximum: 100
offset integer Optional minimum: 0; maximum: 10000

Full JSON Schema

Full JSON Schema

Example input

{
  "schema": "public",
  "table": "items",
  "columns": [
    "id",
    "name"
  ],
  "limit": 10
}

At most 1 provider requests per invocation; timeout: 15 seconds.

Errors

Check the key's expiry, revocation, workspace and allowed operations.

Reuse the same idempotency key only for the same request.

The connection or provider limit has been reached. Check the receipt before retrying.

Test the connection

Open the integration's commands below to inspect parameters and examples. Start with a read command for an account or resource you can access. Refresh your client's tool list, use the returned tool name, and check the execution result and usage. Provider charges and permissions still apply. Never test a write against production data without reviewing it.

Official provider documentation

Type to search…

↑↓ navigate↵ selectEsc close