平台
特点
代理工作室
快速建立和定制您的代理
自主发动机
使用LLMs 引导对话和任务
知识库
使用自定义知识源训练机器人
表格
存储和管理对话数据
渠道
Whatsapp 徽章
WhatsApp
Instagram 徽章
Instagram
FacebookMessenger 徽标
Messenger
Slack 徽标
Slack
所有频道
集成
Hubspot 徽标
HubSpot
Notion 徽标
Notion
Jira 徽标
Jira
Calendly 徽标
Calendly
所有集成
LLM 提供商
OpenAI 徽标
OpenAI
Anthropic 徽标
Anthropic
Groq 徽标
Groq
拥抱脸庞徽标
Hugging Face
全部LLMs
解决方案
对于
企业
实现关键任务生产工作流程自动化
机构
提供完善的代理服务
开发者
探索用于代理开发的强大 API
客户故事
从成功客户那里了解Botpress 如何改变全球业务。
按行业分类
电子商务
教育
财务
接待服务
所有行业
部门
销售
工程学
产品
ITSM
所有部门
按用例
购物助理
潜在客户生成
员工体验
票务管理
所有用例
资源
必要
Academy
通过精心设计的课程学习建造
图书馆
增强人工智能工作流程的资源
博客
有关Botpress 和人工智能代理的见解和最新情况
建筑物
Discord
与成千上万的同行一起交流思想
文件
全面的指南和参考资料
应用程序接口
与外部系统配合使用的参考资料
LLM 排名
比较模式提供商的性能和成本
视频
教程、演示和产品演示
更新日志
了解Botpress 的最新更新
合作伙伴
成为合作伙伴
加入我们的认证专家网络
聘请专家
与合作伙伴和顾问联系
文件
企业
价格
登录
联系方式注册
返回Hub

微软 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

打造令人惊叹的人工智能代理体验。

开始免费使用
箭头图标
了解更多信息,请访问Botpress Academy

利用我们精心挑选的课程、指南和教程,更好更快地构建人工智能代理。

聘请专家

与我们的认证开发人员联系,寻找适合您需求的Botpress 专家。

所有系统运行
SOC 2
认证
GDPR
符合要求
© 2025
平台
价格
代理工作室
自主发动机
知识库
表格
Hub
集成
渠道
LLMs
资源
咨询销售人员
文档
聘请专家
视频
客户故事
API参考
博客
状态
v12 资源
社区
社区支持
成为合作伙伴
成为大使
成为会员
公司
关于
职业机会
新闻中心
法律门户
隐私权
©Botpress 2025