Database Configuration

AskSenseOps supports connections to PostgreSQL, MySQL, SQL Server, and Snowflake. This section explains how to configure each database connection.

Prerequisites

Before configuring a database connection, ensure that you have:

• The hostname or account identifier for the database.
• The database name and other required connection details.
• A valid database username and password.
• Network access from the AskSenseOps server to the database.

For Snowflake, ensure that you also have the account identifier. The warehouse and schema can be provided if required.

Adding a Database Connection

1. Open AskSenseOps.
2. Navigate to Admin and select Connections under Data.
3. Click Add connection.
4. Enter a Connection Name to identify the connection.
5. Optionally, enter a Description.
6. Select the required database under Platform Type.
7. Enter the connection details for the selected database.
8. Test the connection and save it.

Common Fields

The following fields are available for all four database platforms.

Field	Description	Required
Connection Name	Enter a name to identify the connection, such as Production Database.	Yes
Description	Enter optional notes about the connection.	No
Platform Type	Select PostgreSQL, MySQL, SQL Server, or Snowflake.	Yes

PostgreSQL

Select PostgreSQL under Platform Type.

Database Connection

Field	Description	Required
Host	Enter the hostname or IP address of the PostgreSQL server.	Yes
Port	Enter the database server port. The default value is 5432.	Yes
Database	Enter the name of the PostgreSQL database.	Yes

Authentication

Field	Description	Required
Username	Enter the username used to authenticate with the database.	Yes
Password	Enter the password associated with the database user.	Yes

MySQL

Select MySQL under Platform Type.

Database Connection

Field	Description	Required
Host	Enter the hostname or IP address of the MySQL server.	Yes
Port	Enter the database server port. The default value is 5432.	Yes
Database	Enter the name of the MySQL database.	Yes

Authentication

Field	Description	Required
Username	Enter the username used to authenticate with the database.	Yes
Password	Enter the password associated with the database user.	Yes

SQL Server

Select SQL Server under Platform Type.

Database Connection

Field	Description	Required
Host	Enter the hostname or IP address of the SQL Server instance.	Yes
Port	Enter the database server port. The default value is 5432.	Yes
Database	Enter the name of the SQL Server database.	Yes

Authentication

Field	Description	Required
Username	Enter the username used to authenticate with the database.	Yes
Password	Enter the password associated with the database user.	Yes

Snowflake

Select Snowflake under Platform Type.

Snowflake Connection

Field	Description	Required
Account	Enter the Snowflake account identifier, such as xy12345.us-east-1.	Yes
Database	Enter the name of the Snowflake database.	Yes
Warehouse	Enter the warehouse to use for queries, if required.	No
Schema	Enter the schema to use within the database, if required.	No

Authentication

Field	Description	Required
Username	Enter the Snowflake username used for authentication.	Yes
Password	Enter the password associated with the Snowflake user.	Yes

Testing and Saving the Connection

After entering the required details for the selected database:

1. Review the connection details and credentials.
2. Click Test Connection to verify that AskSenseOps can connect to the database.
3. If the test succeeds, click Save Connection to save the configuration.

If the connection test fails, verify the host or account identifier, port where applicable, database name, credentials, and network access.