René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.prisma.io#organization","name":"Prisma","url":"https://www.prisma.io","description":"Prisma makes Prisma ORM, Prisma Postgres and Prisma Compute: a TypeScript ORM, a managed Postgres database, and hosting for TypeScript apps next to that database in one project.","logo":"https://www.prisma.io/images/logo.svg","sameAs":["https://github.com/prisma","https://twitter.com/prisma","https://www.linkedin.com/company/prisma-io","https://www.youtube.com/prismadata","https://www.facebook.com/prisma.io/"]},{"@type":"WebSite","@id":"https://www.prisma.io#website","name":"Prisma","alternateName":"Prisma.io","url":"https://www.prisma.io","description":"Prisma makes Prisma ORM, Prisma Postgres and Prisma Compute: a TypeScript ORM, a managed Postgres database, and hosting for TypeScript apps next to that database in one project.","publisher":{"@id":"https://www.prisma.io#organization"}}]}

{"@context":"https://schema.org","@type":"FAQPage","@id":"https://www.prisma.io/postgres#faq","name":"Prisma Postgres FAQ","url":"https://www.prisma.io/postgres","mainEntity":[{"@type":"Question","name":"Is Prisma Postgres free to use?","acceptedAnswer":{"@type":"Answer","text":"Yes, Prisma Postgres provides free PostgreSQL hosting, needs no credit card and includes 200,000 operations a month across up to 50 databases in a workspace. An operation is one query, read or write, and usage resets at the start of each calendar month. On the Free plan, idle databases cost nothing and you never wake one by hand: the next query does it. Backups and spend limits start on the Starter plan at $10 a month."}},{"@type":"Question","name":"What happens when I reach the Free plan limit?","acceptedAnswer":{"@type":"Answer","text":"Your workspace's databases stop accepting queries until the allowance resets at the start of the next month, or until you upgrade, which usually restores access within a minute. If you need time to export your data first, you can lift the limit for 24 hours from the Console, once per workspace. Paid plans bill operations beyond the included amount at your plan's rate, up to a spend limit if you set one in the Console."}},{"@type":"Question","name":"Can I create a database without signing up?","acceptedAnswer":{"@type":"Answer","text":"Yes. Run npx create-db and you get a Postgres database and its connection string in seconds, with no account and no credit card. Add --json when a coding agent needs machine-readable output. The database is deleted after 24 hours unless you claim it: open the claim link from the output and sign in, and it moves into your workspace under that plan's limits."}},{"@type":"Question","name":"Can I manage my databases from Claude Code, Cursor or Codex?","acceptedAnswer":{"@type":"Answer","text":"Yes, through Prisma's hosted MCP server at https://mcp.prisma.io/mcp, which you connect with your Prisma sign-in. In Claude Code, run claude mcp add --transport http prisma https://mcp.prisma.io/mcp. Cursor adds it from its MCP settings or a one-click link, and Codex through the Prisma plugin. An agent can then create databases, inspect the schema, run SQL, apply schema changes and, on paid plans, restore a backup into a new database. For scripts, there is also a REST API that uses a workspace service token. To keep test writes away from customer data, see hosting a TypeScript test app with a separate database."}},{"@type":"Question","name":"Where do I find my connection string?","acceptedAnswer":{"@type":"Answer","text":"In the Prisma Console: open your project, select Connect to your database, then Generate new connection string. You get two connection strings. Use the pooled one as DATABASE_URL for your app and serverless functions, and the direct one for migrations, Prisma Studio and pg_dump. SSL is required, so keep sslmode=require in the URL. npx create-db also prints a connection string. Once connected, the query-monitoring guide explains how to inspect slow SQL and existing indexes."}},{"@type":"Question","name":"Does Prisma Postgres support pgvector?","acceptedAnswer":{"@type":"Answer","text":"Yes, on every plan, including Free. Enable it with CREATE EXTENSION IF NOT EXISTS vector; from any Postgres client or a migration, then store embeddings in vector columns and run similarity search with pgvector's distance operators. Prisma ORM works with vector columns through raw SQL or TypedSQL, and Prisma Studio can't open tables that contain them yet. See the full list of supported extensions."}},{"@type":"Question","name":"Are backups included?","acceptedAnswer":{"@type":"Answer","text":"Yes, every paid plan includes daily automatic backups. Starter and Pro keep them for 7 days and Business keeps them for 30; the Free plan has none. You restore a backup from the database's Backups tab in the Console, or ask an agent to restore one into a new database through the MCP server. Point-in-time restore is coming in November 2026. To keep your own copy, run pg_dump against the direct connection string, on any plan with available usage."}},{"@type":"Question","name":"Which regions can I choose?","acceptedAnswer":{"@type":"Answer","text":"Six: San Francisco (us-west-1), North Virginia (us-east-1), Paris (eu-west-3), Frankfurt (eu-central-1), Tokyo (ap-northeast-1) and Singapore (ap-southeast-1). You pick the region for each database when you create it in the Console, through MCP or with npx create-db --region. Without the flag, npx create-db picks the region closest to you. For deployed apps, see choosing app and database regions."}},{"@type":"Question","name":"Is Prisma Postgres HIPAA compliant?","acceptedAnswer":{"@type":"Answer","text":"Yes, on the Business plan at $129 a month, with a signed Business Associate Agreement (BAA). HIPAA is not available on the Free, Starter or Pro plans. For comparison, Supabase only offers HIPAA from its Team plan at $599 a month, plus a paid HIPAA add-on. Business also includes SOC 2 Type II and ISO 27001, and GDPR applies on every plan, including Free. See HIPAA on the Business plan for the BAA and scope. Audit reports and control details are in the Prisma Trust Center."}}]}