How to Store JSON Object with TypeORM

Updated: August 31, 2022 By: A Goodman One comment

If you want to store some kind of flexible data with TypeORM, you can save them as JSON. You can specify the column type as simple-json. This helps you store and load Javascript objects with ease.

Let’s examine a concrete example for more clarity.

1. Define an entity called Product:

// Product entity
import {
} from 'typeorm';

@Entity({name: 'products'})
export class Product {
  id: number;

  name: string;

  // Column with JSON data type
  @Column('simple-json', {nullable: true})
  otherInfo: {
    description: string;
    freeShipping: boolean;
    weight: number;
    color: string;

  @Column({default: 0})
  price: number

2. Add a new product to the database:

const productRepository = dataSource.getRepository(Product);
const product = new Product(); = '';

// JSON stuff here
product.otherInfo = {
      description: 'This is a description',
      freeShipping: true,
      weight: 1,
      color: 'red',

product.price = 100;


When viewing your table products in your database, you’ll see this (put your attention on the otherInfo column):

That’s it. Further reading:

You can also check out our database topic page for the latest tutorials and examples.

Notify of
1 Comment
Inline Feedbacks
View all comments
1 year ago

Thank you

Related Articles