Connectors
The Connectors plugins are used to connect to external services, APIs, and databases. These plugins are used to ingest data from external sources, search data, and perform other operations. This is where individuals can leverage Ask Sage with real-time data from external sources.
Table of contents
List of Connectors Plugins & Agents
| Index | Title | Access | Description of the Plugin/Agent | Category |
|---|---|---|---|---|
| 1 | Elastic | Paid users only | This plugin lets you connect to Elastic API | Connector |
| 2 | Postgres | Paid users only | This plugin lets you connect to Postgres database using secrets | Connector |
Elastic
The Elastic plugin lets you connect to your Elastic API to ingest data from external sources.
Before you can use the Elastic plugin, you need to have a secret for the Elastic API.
To do this, you need submit your secret through the prompt window in the following format:
URL|||VERSION|||SCHEMA|||#DESCRIPTION
https://your-elastic-url.com|||v8.1|||schema1,schema2|||# Schema for log data and user data
Step 1 - Navigate to the Ask Sage Prompt Settings section and select Prompt Templates. Followed by then selecting the Connector: Elastic plugin.
Step 2 - Select the secret that is for the Elastic API.
Step 3 - Enter a question you want to know about the data that your Elastic API has. (Does not need to be in a coding format as the plugin will generate the query for you)
Step 4 - Click on the Submit button
Step 5 - Execute the prefilled prompt generated by the plugin, which will query the Elastic API for the specific information you are looking for.
Postgres
The Postgres plugin lets you connect to your Postgres database using secrets.
Similar to the Elastic plugin, you need to have a secret for the Postgres database.
To do this, you need submit your secret through the prompt window in the following format:
POSTGRES-URL|||POSTGRES_VERSION|||LIST OF TABLES SEPARATED BY ,|||TABLE/FIELD TEXT DESCRIPTION TO HELP GUIDE THE BOT
postgresql://user:password@your-database-url.com/your-database-name?sslmode=require|||v14.6|||users,logs,user_logs,prompts|||# Our users table stores user information ## Use created_at to find out when a user signed up ## Use paid to find out if a user is a paid user # The user subscriptions table stores the user subscriptions stripe events such as subscription completion, and cancellations.
Step 1 - Navigate to the Ask Sage Prompt Settings section and select Prompt Templates. Followed by then selecting the Connector: Postgres plugin.
Step 2 - Select the secret that is for the Postgres database.
Step 3 - Enter a question you want to know about the data that your Postgres database has. (Does not need to be in a coding format as the plugin will generate the query for you).
Step 4 - Click on the Submit button
Step 5 - Execute the prefilled prompt generated by the plugin, which will query the Postgres database for the specific information you are looking for.