关于Prisma的数据库基础及非GraphQL访问方式的技术咨询

Great questions about Prisma—let's unpack each one clearly:

1. What databases does Prisma work with, and is it RDBMS or NoSQL? #

First off, Prisma isn't a database itself—it's a modern ORM (Object-Relational Mapper) and data access layer that acts as a bridge between your application and databases. It supports both types of databases:

• RDBMS: PostgreSQL, MySQL, SQLite, SQL Server
• NoSQL: MongoDB

So Prisma doesn't fit into either RDBMS or NoSQL categories; it's a tool that lets you work with both types using a unified, type-safe API.

2. Is the database server created by prisma deploy RDBMS or NoSQL? #

A quick clarification first: prisma deploy (this is a command from older Prisma 1 versions; modern Prisma uses prisma migrate deploy instead) doesn't actually create a database server from scratch. What it does is deploy your data model schema to a database server you've already configured in your Prisma setup.

The type of that database server (RDBMS vs NoSQL) depends entirely on what you specified in your Prisma configuration file (like prisma.yml for Prisma 1, or schema.prisma for Prisma 2+). For example:

• If you connected to PostgreSQL or MySQL, it's an RDBMS server
• If you connected to MongoDB, it's a NoSQL server

If you were using Prisma's old managed service (Prisma Cloud), the default was typically an RDBMS (PostgreSQL), but you could still configure it to use other databases.

3. How to access the database without using GraphQL (e.g., phpMyAdmin or MongoBooster)? #

Since Prisma just sits on top of your underlying database, you can connect directly to the database itself using standard database tools—no need to go through Prisma's GraphQL API. Here's how:

1. Find your database connection details: These are stored in your Prisma configuration file (look for fields like host, port, user, password, database). If you're using a managed Prisma service, you can get these from the service's dashboard.
2. Use the appropriate tool:
   • For MySQL: Open phpMyAdmin, enter the host, port, username, password, and database name to connect. You'll see all your tables and data just like any regular MySQL database.
   • For MongoDB: Launch MongoBooster (or MongoDB Compass), input the MongoDB connection string from your Prisma config, and you can browse collections, documents, and run queries directly.
   • For PostgreSQL: Use tools like pgAdmin, or even the psql command-line tool, with your database credentials.

Once connected, you can perform all standard database operations—read, write, modify data, run queries—just as you would with any standalone database.

内容的提问来源于stack exchange，提问作者Nomura Nori