Skip to main content

Connections

Connections are used to authenticate DB requests made by the agent. This is an optional setting and is only required if the DB requires authentication. ToothFairyAI supports the following connection types:

  • MySQL: This is a popular open-source relational database management system.
  • PostgreSQL: This is a powerful, open-source object-relational database system.
  • SQL Server: This is a relational database management system developed by Microsoft.
  • Oracle: This is a powerful object-relational database management system.

Connections can be created and or edited from the following menu: Settings > Connections > Create

Create a connection​

  1. Click on the Create button.
  2. Fill in the connection name and description(optional).
  3. Select the Connection type from the dropdown menu (MySQL, PostgreSQL, SQL Server, Oracle).
  4. Fill in Host, Port, Database, Username, Password, and any other required fields based on the connection type selected.
  5. Click on the Save button to create the connection.
  6. Enterprise plans can also include the SSH tunneling details.
Note

All the secret fields are encrypted and stored securely. You will not be able to see the secret fields once you save the connection. In case you forget the secret fields, you will need to create a new connection.

Warning

The DB functions are available only for Enterprise plans. Please contact us for more information.