Skip to main content
Glama

Create connection

fastero_create_connection

Create a data connection to a database that signs in with a username and password (Postgres, MySQL, SQL Server, Redshift, Snowflake, Oracle), available to the whole organisation. The credentials given in creds, the password among them, pass through the model and are kept in plain text in the client session transcript, so creating a direct-credential connection in the Fastero web app is the preferred route. OAuth sources such as BigQuery and Google Sheets cannot be created this way and need a browser sign-in; an uploaded CSV or Excel file becomes a connection with fastero_create_file_connection. It connects before saving, so a database it cannot reach is not saved. The refusal names a common cause, such as a wrong password, an unknown host or Oracle service, or a firewall that needs Fastero's address allowed; any other gives the driver's error code and the settings to check. For a Postgres, MySQL, SQL Server, Redshift or Oracle database behind an SSH bastion, creds also takes sshHost, sshPort (22), sshUsername, sshKeyId from fastero_create_ssh_key, and sshHostKey; host is then the database's host as the bastion reaches it, and for Oracle its IP address. A first call without sshHostKey is refused with the bastion's host-key fingerprint, which the person can compare on the bastion; the same call with it as sshHostKey goes ahead. Returns the new connection's _id, the connectionId other tools take. Owners, admins and editors of the organisation can create one.

Input Schema

NameRequiredDescriptionDefault
nameYesThe connection’s name, as people will see it in Fastero.
credsYesCredential fields for the datasource. For SQL: host, port, database, username (not "user"), password, sslMode ("require" for TLS). For SQL Server also encrypt (true or false; on by default for an Azure SQL host). For Oracle, service (the service name, such as ORCLPDB1) in place of database. For Snowflake: account, username, password, warehouse and database.
projectIdNoNot needed: the connection belongs to the whole organisation whichever project is named here (a project’s id, from fastero_list_projects).
datasourceYesDatasource key: pg (not "postgres"), mysql, mysql2, mssql, redshift, snowflake, oracle.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Added

TDQS

A4.7/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations only cover the readOnly/destructive profile, and the description carries the rest itself: credentials pass through the model and persist in plain text in the session transcript, the connection is tested before saving so unreachable databases are not persisted, refusal messages name a cause, and permission is limited to owners/admins/editors. The only shortfall is that the SSH host-key refusal flow is described at length while nothing is said about other failure modes such as duplicate names or credential rotation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loaded with purpose, then exclusions, then the failure/test-before-save behaviour, then SSH, then the return value and permissions — a sensible order. It is a dense single block of roughly 250 words with the SSH edge case consuming nearly a third of it; readable but the wall-of-text format costs it a point.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

No output schema exists, so the description supplies the return contract itself ('the new connection's _id, the connectionId other tools take'). Combined with the mutation side effects, prerequisite tools, permission scope and error semantics, an agent has everything needed to invoke this correctly on the first try.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is already 100%, so a 3 would be the floor, but the description goes well beyond it: it documents the nested creds fields for bastion access (sshHost, sshPort with its default of 22, sshUsername, sshKeyId, sshHostKey), redefines what `host` means when a bastion is used (and that Oracle takes an IP address there), and explicitly neutralises projectId as not needed. That is real semantic value the schema does not supply.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource ('Create a data connection to a database'), enumerates the supported datasources, and immediately distinguishes itself from the two nearest siblings: OAuth sources (BigQuery, Google Sheets) that need a browser sign-in, and fastero_create_file_connection for uploaded CSV/Excel files. An agent can route correctly without opening any schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicit when-to-use with the caveat that the web app is the preferred route because credentials land in the transcript, explicit when-not (OAuth sources, file uploads), and an explicit prerequisite chain for SSH (sshKeyId from fastero_create_ssh_key, host-key fingerprint verification). Exclusions and alternatives are both named.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.