Database & ORM API Key

Sequelize REST API

Promise-based Node.js ORM for SQL databases

Sequelize is a powerful Object-Relational Mapping (ORM) library for Node.js that supports PostgreSQL, MySQL, MariaDB, SQLite, and Microsoft SQL Server. It provides a high-level API for database operations with features like model definitions, associations, transactions, migrations, and query building. Developers use Sequelize to work with SQL databases using JavaScript objects instead of raw SQL queries, making database interactions more maintainable and type-safe.

Base URL https://api.sequelize.org/v6

API Endpoints

Method	Endpoint	Description
POST	`/models`	Define a new database model with attributes and options
GET	`/models/{modelName}`	Retrieve model definition and metadata
POST	`/models/{modelName}/sync`	Synchronize model with database schema
POST	`/models/{modelName}/findAll`	Query multiple records with filtering, sorting, and pagination
POST	`/models/{modelName}/findOne`	Find a single record matching the specified criteria
POST	`/models/{modelName}/create`	Create a new record in the database
PUT	`/models/{modelName}/update`	Update one or more records matching criteria
DELETE	`/models/{modelName}/destroy`	Delete records matching the specified criteria
POST	`/models/{modelName}/bulkCreate`	Insert multiple records in a single operation
POST	`/associations`	Define relationships between models (hasOne, hasMany, belongsTo)
POST	`/transactions`	Start a new database transaction
POST	`/transactions/{transactionId}/commit`	Commit a transaction and persist changes
POST	`/transactions/{transactionId}/rollback`	Rollback a transaction and discard changes
POST	`/query`	Execute raw SQL queries with parameter binding
GET	`/migrations`	List all available database migrations

Code Examples

curl -X POST https://api.sequelize.org/v6/models/User/findAll \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  -H 'Content-Type: application/json' \
  -d '{
    "where": {
      "email": {
        "$like": "%@example.com"
      }
    },
    "limit": 10,
    "order": [["createdAt", "DESC"]]
  }'

const response = await fetch('https://api.sequelize.org/v6/models/User/create', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer YOUR_API_KEY',
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    firstName: 'John',
    lastName: 'Doe',
    email: 'john.doe@example.com',
    age: 30
  })
});

const user = await response.json();
console.log('Created user:', user);

import requests

url = 'https://api.sequelize.org/v6/models/User/findOne'
headers = {
    'Authorization': 'Bearer YOUR_API_KEY',
    'Content-Type': 'application/json'
}
data = {
    'where': {
        'id': 123
    },
    'include': ['posts', 'profile']
}

response = requests.post(url, headers=headers, json=data)
user = response.json()
print(f"Found user: {user['firstName']} {user['lastName']}")

Connect Sequelize to AI

Deploy a Sequelize MCP server on IOX Cloud and connect it to Claude, ChatGPT, Cursor, or any AI client. Your AI assistant gets direct access to Sequelize through these tools:

sequelize_query_records Query database records using Sequelize syntax with filtering, sorting, pagination, and eager loading of associations

sequelize_create_record Create new database records with validation and automatic timestamp handling

sequelize_update_records Update existing records with conditional filtering and bulk update support

sequelize_manage_transactions Execute multiple database operations within ACID-compliant transactions with automatic rollback on errors

sequelize_define_associations Create and manage relationships between models including one-to-one, one-to-many, and many-to-many associations

Deploy in 60 seconds

Describe what you need, AI generates the code, and IOX deploys it globally.

Deploy Sequelize MCP Server →

Sequelize REST API

API Endpoints

Code Examples

Connect Sequelize to AI

Deploy in 60 seconds

Related APIs