Relational Databases

TypeScript

MySQL

Overview

This guide walks you through integrating Prisma ORM into an existing Node.js or TypeScript project. You'll learn how to:

• Connect Prisma to your MySQL database
• Use the Prisma CLI
• Generate a Prisma Client for database access
• Introspect your existing database schema using Prisma Introspection

tip

Migrating from another ORM? Check out our dedicated guides for TypeORM and Sequelize.

Prerequisites

Before you begin, ensure you have:

• An existing Node.js project with a package.json file
• Node.js installed (see system requirements)
• A running MySQL database with at least one table

📌 You'll need your database connection URL, including credentials.

💡 Don’t have a database yet? Try our Quickstart guide with SQLite to explore Prisma ORM.

Step 1: Set Up Prisma

1. Open your terminal and navigate to the project directory containing your package.json.

2. Install Prisma CLI as a development dependency:

npm install prisma --save-dev