Integrate OceanBase MCP Server with Kiro|V4.4.2|OceanBase Database|docs|OceanBase Documentations

Create a table

Enter the prompt "Create a customer table with ID as the primary key and containing fields such as name, age, telephone, and location":

Insert test data

Enter the prompt "Insert 10 pieces of test data":

Create a FastAPI project

Enter the prompt "Create a FastAPI project that generates a RESTful API based on the customer table". Multiple files will be automatically generated. Click Accept All first. You can make secondary modifications if there are any issues.

Since the AI-generated files may vary each time, we will not show the modification process here.

Run the following command to install dependencies in the current directory:

pip install -r requirements.txt

Start the FastAPI project

python3 main.py

View the data in the table

Run curl http://127.0.0.1:8000/customers in the command line or use other request tools to view the data in the table:

curl http://127.0.0.1:8000/customers
[{"name":"Alice","age":28,"telephone":"555-0101","location":"New York","id":1},{"name":"Bob","age":35,"telephone":"555-0102","location":"Los Angeles","id":2},{"name":"Carol","age":42,"telephone":"555-0103","location":"Chicago","id":3},{"name":"David","age":31,"telephone":"555-0104","location":"Houston","id":4},{"name":"Eve","age":26,"telephone":"555-0105","location":"Phoenix","id":5},{"name":"Frank","age":39,"telephone":"555-0106","location":"Philadelphia","id":6},{"name":"Grace","age":33,"telephone":"555-0107","location":"San Antonio","id":7},{"name":"Henry","age":45,"telephone":"555-0108","location":"San Diego","id":8},{"name":"Ivy","age":29,"telephone":"555-0109","location":"Dallas","id":9},{"name":"Jack","age":37,"telephone":"555-0110","location":"San Jose","id":10}]

The create, read, update, and delete (CRUD) code has been generated.

from database import db
from models import CustomerCreate, CustomerUpdate
from typing import List, Optional

class CustomerCRUD:

 @staticmethod
 def get_all_customers() -> List[dict]:
     query = "SELECT * FROM customer ORDER BY id"
     return db.execute_query(query)

 @staticmethod
 def get_customer_by_id(customer_id: int) -> Optional[dict]:
     query = "SELECT * FROM customer WHERE id = %s"
     result = db.execute_query(query, (customer_id,))
     return result[0] if result else None

 @staticmethod
 def create_customer(customer: CustomerCreate) -> dict:
     query = """
     INSERT INTO customer (name, age, telephone, location) 
     VALUES (%s, %s, %s, %s)
     """
     customer_id = db.execute_insert(
         query, 
         (customer.name, customer.age, customer.telephone, customer.location)
     )
     return CustomerCRUD.get_customer_by_id(customer_id)

 @staticmethod
 def update_customer(customer_id: int, customer: CustomerUpdate) -> Optional[dict]:
     # Build dynamic update query
     update_fields = []
     params = []

     if customer.name is not None:
         update_fields.append("name = %s")
         params.append(customer.name)
     if customer.age is not None:
         update_fields.append("age = %s")
         params.append(customer.age)
     if customer.telephone is not None:
         update_fields.append("telephone = %s")
         params.append(customer.telephone)
     if customer.location is not None:
         update_fields.append("location = %s")
         params.append(customer.location)

     if not update_fields:
         return CustomerCRUD.get_customer_by_id(customer_id)

     query = f"UPDATE customer SET {', '.join(update_fields)} WHERE id = %s"
     params.append(customer_id)

     db.execute_query(query, tuple(params))
     return CustomerCRUD.get_customer_by_id(customer_id)

 @staticmethod
 def delete_customer(customer_id: int) -> bool:
     query = "DELETE FROM customer WHERE id = %s"
     db.execute_query(query, (customer_id,))
     return True

 customer_crud = CustomerCRUD()

Integrate OceanBase MCP Server with Kiro

Prerequisites

Step 1: Obtain the database connection information

Notice

Step 2: Configure OceanBase MCP Server

Clone the OceanBase MCP Server repository

Install dependencies

Configure OceanBase MCP Server in Kiro

Step 3: Use FastAPI to quickly create a RESTful API project