base on Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i. <p align="center"><img src="logo.svg" width="100" alt="Sequelize logo" /></p> <h1 align="center" style="margin-top: 0;"><a href="https://sequelize.org">Sequelize</a></h1> [](https://www.npmjs.com/package/@sequelize/core) [](https://www.npmjs.com/package/@sequelize/core) [](https://github.com/sequelize/sequelize/graphs/contributors) [](https://opencollective.com/sequelize#section-contributors) [](https://opencollective.com/sequelize) [](https://github.com/sequelize/sequelize) [](https://github.com/semantic-release/semantic-release) [](https://opensource.org/licenses/MIT) Sequelize is an easy-to-use and promise-based [Node.js](https://nodejs.org/en/about/) [ORM tool](https://en.wikipedia.org/wiki/Object-relational_mapping) for [Postgres](https://en.wikipedia.org/wiki/PostgreSQL), [MySQL](https://en.wikipedia.org/wiki/MySQL), [MariaDB](https://en.wikipedia.org/wiki/MariaDB), [SQLite](https://en.wikipedia.org/wiki/SQLite), [DB2](https://en.wikipedia.org/wiki/IBM_Db2_Family), [Microsoft SQL Server](https://en.wikipedia.org/wiki/Microsoft_SQL_Server), [Snowflake](https://www.snowflake.com/), [Oracle DB](https://www.oracle.com/database/) and [Db2 for IBM i](https://www.ibm.com/support/pages/db2-ibm-i). It features solid transaction support, relations, eager and lazy loading, read replication and more. Would you like to contribute? Read [our contribution guidelines](./CONTRIBUTING.md) to know more. There are many ways to help! 😃 ## :computer: Getting Started Ready to start using Sequelize? Head to [sequelize.org](https://sequelize.org) to begin! - [Our Getting Started guide for Sequelize 6 (stable)](https://sequelize.org/docs/v6/getting-started) - [Our Getting Started guide for Sequelize 7 (alpha)](https://sequelize.org/docs/v7/getting-started) ## :money_with_wings: Supporting the project Do you like Sequelize and would like to give back to the engineering team behind it? We have recently created an [OpenCollective based money pool](https://opencollective.com/sequelize) which is shared amongst all core maintainers based on their contributions. Every support is wholeheartedly welcome. ❤️ ## :pencil: Major version changelog Please find upgrade information to major versions here: - [Upgrade from v5 to v6](https://sequelize.org/docs/v6/other-topics/upgrade-to-v6) - [Upgrade from v6 to v7](https://sequelize.org/docs/v7/other-topics/upgrade-to-v7) ## :book: Resources - [Documentation](https://sequelize.org) - [Databases Compatibility Table](https://sequelize.org/releases/) - [Changelog](https://github.com/sequelize/sequelize/releases) - [Discussions](https://github.com/sequelize/sequelize/discussions) - [Slack](https://sequelize.org/slack) - [Stack Overflow](https://stackoverflow.com/questions/tagged/sequelize.js) ### :wrench: Tools - [CLI](https://github.com/sequelize/cli) - [For GraphQL](https://github.com/mickhansen/graphql-sequelize) - [For CockroachDB](https://github.com/cockroachdb/sequelize-cockroachdb) - [Awesome Sequelize](https://sequelize.org/docs/v7/other-topics/resources/) - [For YugabyteDB](https://github.com/yugabyte/sequelize-yugabytedb) ### :speech_balloon: Translations - [English](https://sequelize.org) (Official) - [中文文档](https://github.com/demopark/sequelize-docs-Zh-CN) (Unofficial) ## :warning: Responsible disclosure If you have security issues to report, please refer to our [Responsible Disclosure Policy](./SECURITY.md) for more details. ", Assign "at most 3 tags" to the expected json: {"id":"1220","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"