This tutorial builds a mini-CRM from scratch using OceanBase as the database, Sequelize as the ORM (via the MySQL driver), and Express as the API server — covering project setup, model definition, and full CRUD routes.
OceanBase is MySQL-compatible, so Sequelize connects with dialect: "mysql" and the mysql2 driver — no custom adapter needed. sequelize.sync() auto-creates tables, and all standard Sequelize methods (findAll, create, update, destroy) work out of the box.
By the end you'll have a running REST API on port 3000 that creates, reads, updates, and deletes contacts in OceanBase, testable with Postman or Thunder Client.

Database Oceanbase

Content

What we are going to build: A mini-CRM system

Setting up the database

Setting up the project

Configuring Sequelize

Configuring the Database Connection

Defining data models

Building the Express application

Creating a new contact

Getting all contacts

Getting a contact by ID

Updating a contact

Deleting a contact

Conclusion

Keep Reading

View all posts

ENGINEERING

From Complex to Simple: How We Built seekdb for the AI Era

AI era doesn't need another heavy, complex enterprise database. It needs agility. It needs flexibility. We went back to the drawing board to understand what an AI application actually needs from a database. Our answer is OceanBase seekdb

Mike LiuNovember 28, 2025

ENGINEERING

Beyond Fine-tuning: Solving DABstep's Hard Mode with Versioned Assets

On the DABstep Global Leaderboard, OceanBase DataPilot agent has secured the top spot, maintaining a significant lead over the runner-up for a month. The secret to our SOTA results was a fundamental shift in engineering paradigm: moving from "Prompt Engineering" to "Asset Engineering."

Zion GaoJanuary 9, 2026

ENGINEERING

Cross-Cloud DR Networking: Sync Methods & Paths

In this post, we’ll break down the sync methods, network paths, latency factors, and cost trade-offs that shape whether a cross-cloud deployment is viable in practice.

Tim ZhangApril 20, 2026