JSONファイルからSQLデータベースへのインポート方法

{
  "users": [
    {
      "id": 1,
      "name": "田中",
      "age": 30
    },
    {
      "id": 2,
      "name": "佐藤",
      "age": 25
    }
  ]
}

import json

with open('data.json', 'r', encoding='utf-8') as f:
    data = json.load(f)

import pymysql

connection = pymysql.connect(
    host='localhost',
    user='root',
    password='password',
    database='my_database'
)

cursor = connection.cursor()

for user in data['users']:
    sql = "INSERT INTO users (id, name, age) VALUES (%s, %s, %s)"
    cursor.execute(sql, (user['id'], user['name'], user['age']))

connection.commit()