View as Json

Mysql(Drizzle) Provider

This provider sets up MySQL connectivity with Drizzle ORM for nextjs projects.

Official Docs

Installation Guide

Run the following command:

npx servercn-cli@latest add pr mysql-drizzle

Add the following scripts to your package.json:

package.json
{
  "scripts": {
    "db:generate": "drizzle-kit generate",
    "db:migrate": "drizzle-kit migrate",
    "db:studio": "drizzle-kit studio",
    "db:push": "npx drizzle-kit push"
  },
}

Usage Example

import db from "@/db/connection";
src/app/api/route.ts
import { usersTable } from "@/db";
import db from "@/db/connection";
import { NextResponse } from "next/server";
 
export const GET = async () => {
  try {
    const user: typeof usersTable.$inferInsert = {
      name: "John",
      age: 30,
      email: "john@example.com"
    };
    await db.insert(usersTable).values(user);
 
    const users = await db.select().from(usersTable);
    console.log({ users });
 
    return NextResponse.json(
      {
        success: true,
        data: users
      },
      { status: 200 }
    );
  } catch (error) {
    console.error("Delete error:", error);
 
    return NextResponse.json(
      {
        success: false,
        message: "Internal server error"
      },
      { status: 500 }
    );
  }
};

File & Folder Structure

Loading files...

Installation

npx servercn-cli@latest add pr mysql-drizzle