# ORM v6.17.0, New Usage Metrics & Direct Connections in GA for Prisma Postgres URL: https://www.prisma.io/blog/orm-v6-17-0-new-usage-metrics-and-direct-connections-in-ga-for-prisma-postgres Published: 2025-10-08 Authors: Nikolas Burk Tags: orm, announcement Description: Prisma ORM v6.17.0 is out with fixes and improvements. Connecting to Prisma Postgres via your favorite ORM/DB tool is now GA. Read the full update. > Blog posts describe Prisma as it was on the date shown and are not kept current. Before implementing from a post, check the documentation index at https://www.prisma.io/docs/llms.txt and the changelog at https://www.prisma.io/changelog.md. > For an index of every published post, fetch https://www.prisma.io/blog/llms.txt. We just released Prisma [ORM v6.17.0](https://pris.ly/release/6.17.0) with several bug fixes and improvements. Additionally, connecting to Prisma Postgres using your favorite ORM or DB tool is now Generally Available. Check out the article for even more updates! ## Using Prisma Postgres with any tool is ready for production [#using-prisma-postgres-with-any-tool-is-ready-for-production] *Want to use Prisma Postgres with Drizzle, Kysely or connect to it from a DB GUI like Postico or TablePlus?* Using Prisma Postgres with Prisma ORM is great because it gives you connection pooling, global caching and overall an amazing DX. That being said, we understand that preferences vary and some developers prefer to use plain SQL or lower-level query builders in their applications. As of this release, these ways for connecting to Prisma Postgres are now officially Generally Available (GA) and can be used in your production apps! ![](https://www.prisma.io/blog/orm-v6-17-0-new-usage-metrics-and-direct-connections-in-ga-for-prisma-postgres/imgs/1b4d23d5d2d93055fe604b9767ae70064dd6b041-2470x1030.png) You can connect using Drizzle, Kysely, TypeORM, `psql`, or *any other* Postgres-compatible library, database migration [tools like Atlas](https://atlasgo.io/) or interfaces like DBeaver, Postico, and more. ## New usage metrics available in Console Dashboard [#new-usage-metrics-available-in-console-dashboard] *Want to see all your Prisma Postgres usage at a glance?* The Dashboard in Prisma Console now gives you a clear, at-a-glance view of Prisma Postgres usage so you can make faster, smarter decisions. ![](https://www.prisma.io/blog/orm-v6-17-0-new-usage-metrics-and-direct-connections-in-ga-for-prisma-postgres/imgs/e3899399a9d59b64fbedee79607fc34819eced5a-2560x1664.png) Here's what's new: * Key metrics * Estimated upcoming invoice * Total storage used * Total DBs * Overall usage * Cumulative operations * Operations per day ## Bug fixes and improvements in Prisma ORM v6.17.0 [#bug-fixes-and-improvements-in-prisma-orm-v6170] * Added support for Entra ID (ActiveDirectory) authentication parameters for the MS SQL Server driver adapter. For example, you can use the `config` object to configure [DefaultAzureCredential](https://learn.microsoft.com/en-gb/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility): ```ts import { PrismaMssql } from '@prisma/adapter-mssql' import { PrismaClient } from '@prisma/client' const config = { server: 'localhost', port: 1433, database: 'mydb', authentication: { type: 'azure-active-directory-default', }, options: { encrypt: true, }, } const adapter = new PrismaMssql(config) const prisma = new PrismaClient({ adapter }) ``` Learn more in this [PR](https://github.com/prisma/orm/pull/28156/files#diff-351f5d894309f058776099c378e3956271f34f34c04e2b54576045b9773ab61aR61-R62). * Relaxed the support package range for `@opentelemetry/instrumentation` to be compatible with `">=0.52.0 <1"`. Learn more in this [PR](https://github.com/prisma/orm/pull/28199/files). * Added Codex CLI detection, ensuring dangerous Prisma operations are not executed by Codex without explicit user consent. Learn more in this [PR](https://github.com/prisma/orm/pull/28159). * Fixed JSON column handling when using a MariaDB database. Learn more in this [PR](https://github.com/prisma/orm/pull/28211). * Restored the original behaviour of group-by aggregations where they would refer to columns with explicit table names which fixes a regression that would result in ambiguous column errors. Learn more in this [PR](https://github.com/prisma/prisma-engines/pull/5629). ## Preparing for the future of Prisma ORM [#preparing-for-the-future-of-prisma-orm] We [recently](https://pris.ly/release/6.16.0) made the Rust-free Prisma ORM, ESM-first `prisma-client` generator and Prisma Config Generally Available. Together, they form the future of Prisma ORM. As of today, you still need to opt-into using these features, however they'll become the default with the upcoming v7 launch. We recommend that you give them a try already today! Here's what you need to do: ### 1. Configure your Prisma schema [#1-configure-your-prisma-schema] On the `generator` block in your Prisma schema: * define `provider = "prisma-client"` and define an `output` path to use the new ESM-first generator * add `engineType = "client"` to use Prisma ORM without Rust engines ```prisma generator client { provider = "prisma-client" output = "../src/generated/prisma" engineType = "client" } ``` Afterwards, run `prisma generate` so that your generated Prisma Client gets updated. We also recommend deleting and re-installing `node_modules` via `npm install` so that the previous version of `prisma-client-js` inside `node_modules` gets cleared properly. ### 2. Install the driver adapter for your database [#2-install-the-driver-adapter-for-your-database] If you're using Prisma ORM without Rust engines, you have full control over the database connections by using your preferred JS-native driver library. For example, if you're using PostgreSQL, you can use the `pg` driver via the `@prisma/adapter-pg` driver adapter. First, install the npm library: ``` npm install @prisma/adapter-pg ``` Then use the driver adapter to instantiate `PrismaClient`: ```ts import { PrismaClient } from './generated/prisma' import { PrismaPg } from '@prisma/adapter-pg' const adapter = new PrismaPg({ connectionString: env.DATABASE_URL }) const prisma = new PrismaClient({ adapter }) // ... send queries using `prisma` like before ``` ### 3. Use Prisma Config [#3-use-prisma-config] Prisma Config is the new way for configuring your Prisma projects directly in TypeScript. To start using it, you can simply create a `prisma.config.ts` file and set it up as follows: ```ts import { defineConfig } from "prisma/config"; export default defineConfig({ // put config options here }); ``` As an example, this is what it looks like when you configured the location of your Prisma schema and migrations directory via Prisma Config: ```ts import path from "node:path"; import { defineConfig } from "prisma/config"; export default defineConfig({ schema: path.join("prisma", "schema.prisma"), migrations: { path: path.join("prisma", "migrations"), }, }); ``` For a full reference of the options that can be used in Prisma Config, see the [docs](https://www.prisma.io/docs/orm/v7/reference/prisma-config-reference). > **Note**: When using Prisma Config, [automatic loading](https://github.com/prisma/orm/issues/15620) of env vars is disabled. This means you need to [manually load env vars](https://www.prisma.io/docs/orm/v7/reference/prisma-config-reference#using-environment-variables), e.g. using `dotenv`. ## Try it out and share your feedback [#try-it-out-and-share-your-feedback] This week we've launched direct TCP connections for Prisma Postgres, this means you can now connect to Prisma Postgres with any tool in your production applications! Additionally, we've added new musage metrics that show give you the most important information about your database at a single glance! Let us know your thoughts, questions and feedback [on X](https://pris.ly/x) and join the conversation [on Discord](https://pris.ly/discord).