Platform
Ciri
Studio Ejen
Bina dan sesuaikan ejen anda dengan pantas
Enjin Autonomi
guna LLMs untuk membimbing perbualan dan tugasan
Pangkalan Pengetahuan
Latih bot anda dengan sumber pengetahuan tersuai
Jadual
Menyimpan dan menguruskan data perbualan
Saluran
Whatsapp Lambang
WhatsApp
Instagram Lambang
Instagram
Facebook Messenger logo
Messenger
Slack logo
Slack
Semua saluran
Integrasi
Logo Hubspot
HubSpot
Notion logo
Notion
Logo Jira
Jira
Calendly logo
Calendly
Semua integrasi
LLM Pembekal
OpenAI logo
OpenAI
Anthropic logo
Anthropic
Groq logo
Groq
Logo HuggingFace
Hugging Face
Semua LLMs
Penyelesaian
Bagi
Perusahaan
Automasi aliran kerja pengeluaran kritikal misi
Agensi
Menyediakan perkhidmatan ejen yang canggih
Pemaju
Terokai API yang teguh untuk pembangunan ejen
Cerita Pelanggan
Ketahui daripada pelanggan yang berjaya bagaimana Botpress mengubah perniagaan di seluruh dunia.
Mengikut Industri
E-dagang
Pendidikan
Kewangan
Hospitaliti
Semua industri
Mengikut Jabatan
Jualan
Kejuruteraan
Produk
ITSM
Semua jabatan
Mengikut Kes Penggunaan
Pembantu Beli-belah
Penjanaan Utama
Pengalaman Pekerja
Pengurusan Tiket
Semua kes penggunaan
Sumber
Penting
Academy
Belajar membina melalui kursus yang dipilih susun
Perpustakaan
Sumber untuk meningkatkan aliran kerja AI anda
Blog
Cerapan dan kemas kini tentang Botpress dan ejen AI
bangunan
Discord
Sertai beribu-ribu rakan sebaya dan kongsi idea
Dokumen
Panduan dan rujukan yang komprehensif
API
Bahan rujukan untuk digunakan dengan sistem luaran
LLM Kedudukan
Bandingkan prestasi dan kos untuk pembekal model
Video
Tutorial, tunjuk cara dan panduan produk
Changelog
Ikuti perkembangan terkini Botpress kemas kini
Rakan kongsi
Menjadi Rakan Kongsi
Sertai rangkaian pakar bertauliah kami
Upah Pakar
Berhubung dengan rakan kongsi dan perunding
Dokumen
Perusahaan
Harga
Log masuk
KenalanDaftar
kembali ke Hub

Microsoft SQL

v1.0.1
Pasang pada Ruang Kerja anda
Diselenggara oleh 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'
```

Bina Lebih Baik dengan Botpress

Cipta pengalaman ejen AI yang menakjubkan.

Mulakan - ia percuma
Ikon anak panah
Maklumat lanjut di Botpress Academy

Bina ejen AI dengan lebih baik dan pantas dengan koleksi kursus, panduan dan tutorial kami yang dipilih susun.

Upah Pakar

Berhubung dengan pembangun bertauliah kami untuk mencari pembina pakar yang sesuai dengan keperluan anda.

Semua Sistem Operasi
SOC 2
Diperakui
GDPR
Patuh
© 2025
Platform
Harga
Studio Ejen
Enjin Autonomi
Pangkalan Pengetahuan
Jadual
Hub
Integrasi
Saluran
LLMs
Sumber
Bercakap dengan Jualan
Dokumentasi
Upah Pakar
Video
Cerita Pelanggan
Rujukan API
Blog
Status
Sumber v12
Komuniti
Sokongan Komuniti
Menjadi Rakan Kongsi
Menjadi Duta Besar
Menjadi Ahli Gabungan
Syarikat
Tentang
Kerjaya
Berita & Akhbar
Undang
Privasi
© Botpress 2025