平台
特點
代理工作室
快速建立和自訂您的代理
自主引擎
使用LLMs 來引導對話和工作
知識庫
使用自訂知識來源訓練您的機器人
表格
儲存及管理對話資料
頻道
Whatsapp 標誌
WhatsApp
Instagram
Instagram
FacebookMessenger 標誌
Messenger
Slack 標誌
Slack
所有頻道
整合
Hubspot 標誌
HubSpot
Notion 標誌
Notion
Jira 標誌
Jira
Calendly 標誌
Calendly
所有整合
LLM 提供者
OpenAI 標誌
OpenAI
Anthropic 標誌
Anthropic
Groq 標誌
Groq
HuggingFace 標誌
Hugging Face
所有LLMs
解決方案
適用於
企業
自動執行關鍵任務的生產工作流程
代理機構
提供精密的代理服務
開發人員
探索用於代理程式開發的強大 API
客戶故事
向成功客戶了解Botpress 如何改變全球業務。
按行業
電子商務
教育
財務
接待服務
所有行業
部門
銷售
工程設計
產品
ITSM
所有部門
按使用個案
購物助理
潛在客戶開發
員工體驗
票務管理
所有使用個案
資源
必要
Academy
透過精選課程學習建立
圖書館
增強您 AI 工作流程的資源
部落格
有關Botpress 和 AI 代理的洞察與更新
建築
Discord
加入數以千計的同行並分享想法
文件
全面的指南和參考資料
API
與外部系統搭配使用的參考資料
LLM 排名
比較模型提供者的效能與成本
影片
教學、示範和產品導覽
變更日誌
隨時掌握Botpress 的最新更新
合作夥伴
成為合作夥伴
加入我們的認證專家網路
聘請專家
與合作夥伴和顧問連線
文件
企業
定價
登入
聯絡人註冊
返回 Hub

Microsoft SQL

v1.0.1
在工作區上安裝
由Simply Great Bots維護
  ## Botpress SQL Integration

### What it is
This integration enables your chatbot to directly interact with SQL databases. Perform various database operations like creating tables, inserting data, and querying directly through your chatbot. 

### How it Works
When this integration is enabled, it allows the bot to execute SQL commands directly from within Botpress using the configured database credentials. Here's how you can utilize the SQL capabilities:

- **Create Table**: Easily define and create new tables.
- **Insert Data**: Insert new records into your tables.
- **Update Data**: Modify existing data.
- **Delete Data**: Remove unwanted data.
- **Query Data**: Retrieve information based on specific queries.

#### Setting Up SQL and NGROK

To set up SQL and NGROK for your chatbot integration, follow these steps:

1. Install and configure SQL Server: Install SQL Server on your machine or use a cloud-based SQL service. Make sure you have the necessary credentials (username and password) to access the SQL server. 

Server Settings in SQL Server Configuration Manager:
Enable TCP/IP: Ensure that TCP/IP protocol is enabled in the SQL Server Configuration Manager. Navigate to SQL Server Network Configuration -> Protocols -> TCP/IP and enable it if it's not already enabled. Under IP Addresses set IPALL TCP Port to the port of your choosing (Default is 1433)

2. Configure NGROK: NGROK allows you to expose your local server to the internet. Download and install NGROK, then follow the instructions to set up a tunnel to your local SQL server. This should point to the port from above.

3. Update Botpress configuration: In your Botpress configuration file, specify the SQL server details, including the username, password, instance name, database name, and port number.


### Configuration Details
- **User**: The username for your SQL account.
- **Password**: The password for your SQL account.
- **Instance Name**: The name of your server instance.
- **Database**: Name of the database to be accessed.
- **Port**: The port number your database listens on. This should be the NGROK forwarding port from the `Configure NGROK` section.

### Actions

#### Create Table 

This action allows you to create a new table by providing a name for the table and a stringified JSON object that defines the table's structure. The JSON object must have an array called "columns" which contains the column definitions.

```Example: 
{
  "columns": [
    { "name": "EmployeeId", "type": "INT", "required": true },
    { "name": "FirstName", "type": "VARCHAR", "size": 100, "required": true },
    { "name": "LastName", "type": "VARCHAR", "size": 100, "required": true },
    { "name": "JobTitle", "type": "VARCHAR", "size": 100, "required": true }
  ]
}
```

#### Drop Table

This action allows you to drop a table from the database. Provide the name of the table you want to drop.

```Example:
TableName = "MyEmployees"
```

#### Insert Data
 
 This action allows you to insert data into the table. Provide an array of objects, where each object represents a row of data. Each object should have properties corresponding to the column names and their respective values.

  ```Example: [
  {
    "EmployeeId": 1,
    "FirstName": "John",
    "LastName": "Doe",
    "JobTitle": "Software Engineer"
  },
  {
    "EmployeeId": 2,
    "FirstName": "Jane",
    "LastName": "Smith",
    "JobTitle": "Project Manager"
  },
  {
    "EmployeeId": 3,
    "FirstName": "Alice",
    "LastName": "Johnson",
    "JobTitle": "UX Designer"
  },
  {
    "EmployeeId": 4,
    "FirstName": "Bob",
    "LastName": "Brown",
    "JobTitle": "Data Analyst"
  }
]
```

#### Delete Data

This action allows you to delete data from the table based on specific conditions. Provide the conditions to identify the rows to be deleted.

```Example:
Conditions: FirstName = 'Jane' AND LastName = 'Smith'
```

#### Update Data

This action allows you to update existing data in the table. Provide the column names and their new values for the rows you want to update, along with the condition to identify the rows to be updated.

  ```Example: 
  Data = {
    JobTitle: 'Senior Software Engineer'
  }

  Conditions: EmployeeId = 1
  ```

### Query Data
This action allows you to retrieve information from the table based on specific queries. Use the query statement to specify the columns you want to retrieve.

```Example: 
SELECT * FROM MyEmployees WHERE JobTitle = 'Senior Software Engineer'
```

使用Botpress建立更好的網站

打造驚人的 AI 代理體驗。

開始使用 - 免費
箭頭圖示
進一步了解Botpress Academy

使用我們精心挑選的課程、指南和教學,更好更快地建立 AI 代理。

聘請專家

與我們的認證開發人員聯繫,尋找適合您需求的專業建築商。

所有系統運作正常
SOC 2
認證
GDPR
符合規定
© 2025
平台
定價
代理工作室
自主引擎
知識庫
表格
Hub
整合
頻道
LLMs
資源
與銷售人員交談
文件
聘請專家
影片
客戶故事
API 參考資料
部落格
狀態
v12 資源
社區
社區支援
成為合作夥伴
成為大使
成為會員
公司簡介
關於
工作機會
新聞
法律條款
隱私權
©Botpress 2025