Neon

N

Neon

The official Neon Database Discord

Join

šŸ™ļ½œfeedback

ā“ļ½œquestions-and-answers

🐘|postgres

extended-salmon
extended-salmon9/12/2025

New to NEON - some questions about icons and querying views from Colab.

Hey folks - a client shared access to a database with me via Neon. In the console I can see many tables and what I believe is a view. See icons in the attached image. Is that second icon indicating a view? I've also following the instructions at https://neon.com/docs/ai/ai-google-colab to connect to the database from colab. I don't see any of the views there but I can see and query the tables. Has anyone come across a similar issue? When I'm following the "Retrieve your database connection string" instructions is there something additional required to expose existing views?...
No description
exotic-emerald
exotic-emerald9/12/2025

security_invoker = on

I have a VIEW in my local DB rining in Docker with POstgres v15. Works all good. I tried to migrate my DB in Neon and got and error "Error: Invalid options boolean value for securityInvoker: on" I figured out the probably the way how this works in Neon is different because after removing the security_invoker = on clause from my SQL statement solved the issue, and I could migrate in Neon wihtout any problem. I had to drop the table and recreate it without the secoruty innvoker. So my new down migration file looks like this: ...
quickest-silver
quickest-silver9/11/2025

$50/month with zero users?

Hey team šŸ‘‹ I haven’t even launched my app yet, but the current pricing already feels a bit ridiculous for my use case. I’m building a local-first app with PowerSync, which needs a constant DB connection. To keep things simple I need two branches (prod + dev). Each one requires the minimum 0.25 CU, so that’s 0.5 CU total....
correct-apricot
correct-apricot9/11/2025

Supabase to Neon

Can anyone help me with importing from Supabase to Neon?
genetic-orange
genetic-orange9/10/2025

Clerk + Neon RLS configuration

Hello, I have setup Clerk with Neon/Drizzle but am getting RLS errors in production when I enable RLS on the Users table: ``` query: 'select "id", "clerkId", "firstName", "lastName", "email", "role", "analyticsEnabled", "errorMonitoringEnabled" from "User" where "User"."clerkId" = $1', params: [Array], [cause]: Error [NeonDbError]: Server error (HTTP status 500): "{"message":"could not set up the JWT authorization database extension","code":"","detail":null,"hint":null,"position":null,"internalPosition":null,"internalQuery":null,"severity":"","where":null,"table":null,"column":null,"schema":null,"dataType":null,"constraint":null,"file":null,"line":null,"routine":null}"...
eastern-cyan
eastern-cyan9/10/2025

Storage limit issues, not matching DB size.

Hello all, I have a problem with my free plan. It says I have gone over the limit for storage, it went from 400 mb to 3.84 mb in one day. I have cleaned the database, I have vacuumed, and when I check the DB size it says around 72 mb now. What is the issue?
No description
ambitious-aqua
ambitious-aqua9/10/2025

Free plan compute hours exceeded

Hi, I am on the free plan and got an email saying that I have exceeded 50 compute hours included in the free plan. The way I understand calculation of compute hours works is: 1. if I CU is used for 1 hour, then 1 compute hour is used 2. if 0.25CU is used for 4 hours, then 1 compute hour is used...
No description
equal-aqua
equal-aqua9/10/2025

Getting "pq: unnamed prepared statement does not exist" error

Hi! I'm getting "pq: unnamed prepared statement does not exist" errors when using pooled connections (-pooler) Tech stack: React + Go + database/sql + sqlc. Setup:...
flat-fuchsia
flat-fuchsia9/9/2025

RBAC Not Working

Hi Neon, I have an organization with a few projects. How do I provision users within the organization and then restrict them to specific projects? I tried going the Collaborators route but that isnt working...
fascinating-indigo
fascinating-indigo9/9/2025

Your project has exceeded the data transfer quota. Upgrade your plan to increase limits.

I can see available compute in UI with 1gb public transfer with 0.01gb storage on a paid plan, but still getting the above error. Any idea why? Project ID is: green-unit-83502328
stuck-chocolate
stuck-chocolate9/8/2025

Separate Authentication providers / JWKS urls for branches

We are using Stytch for Auth and Neon RLS for our database. Now it seems we can only set a single JWK issuer per project. Is it possible to set multiple based on different branches. For example; a development JWK URL and a production JWK URL? Thanks, Chris...
optimistic-gold
optimistic-gold9/6/2025

neon dashboard error i guess.

today i noticed something strange in my side app and when i logged in to neon dashboard to check raw data from the database from ten projects i only have one the rest gone but my app are still using the database url string and still works.
xenial-black
xenial-black9/5/2025

Query execution is extremely slow today

Am I the only one who's experiencing very slow (10s of secs) query execution today, both from my app running locally and even when trying to look into the data in Neon Console? I've tried to troubleshoot it, suspecting some network issue on my end, but it doesn't seem to be the case. Look at the attached screenshot from DevTools for Neon Console loading a list of tables. The SQL queries were waiting for a server response for 1.5 minutes
No description
equal-aqua
equal-aqua9/5/2025

Maximum Postgres connections

Hi! I’m using Neon on the free plan with the pooled endpoint (pgBouncer). I saw in the docs that pgBouncer supports up to 10,000 client connections, but I couldn’t find what the actual maximum number of Postgres connections is for the free plan. Could you clarify what the max active database connections are when using the pooled endpoint on the free tier?
correct-apricot
correct-apricot9/5/2025

connect page not working

when i press on "Connect" button on dashboard, to veiw connection data i get "Something went wrong"
fair-rose
fair-rose9/3/2025

Is there a way to get a higher free limits

I have founded an IMDb like website exclusivly for the Egyptian cinema , Although I don't get much traffic , but the egress and compute time are really high , although I optimized queries as much as I can but it is the nature of the app , I just want higher limits until I just make enough revenue to pay for the subscription
plain-purple
plain-purple9/2/2025

Very high amount of compute hours

Hello, I just have a question about how I can use the monitoring tab to get a breakdown of my compute. As of now, it says I have gone through 37 compute hours in about a day, which seems dangerously high. Does anyone have advice on how I can get more information regarding what queries are causing this high amount of hours? I'm using the monitoring tab and I don't see anything glaring. I attached screenshots of my monitoring tab and query history, would be great if someone could tell me if these...
No description
rival-black
rival-black9/2/2025

Neon Auth - Gap in Permissions

Hello, Firstly, I'd like to say thank you for the excellent tech! I'm loving Neon as a database platform. Alright, now let me describe what's goin on: I am working on integrating my Next.js application with Neon Auth, and I'm attempting to set up RBAC and permissions for my application's users. I have found what feels like a gap in usability for me integrating Neon Auth into my application (which makes sense given the beta nature of this feature)....
No description
correct-apricot
correct-apricot9/2/2025

Can different branches use different privatelinks?

For AWS, can branches connect to different privatelinks? For example I want my prod DB on one VPC, and all other branches on a separate VPC
harsh-harlequin
harsh-harlequin9/1/2025

How To Import Correctly?

I recently started a branch and used the development function. I now have 2 different databases entirely thanks to being a novice an vibe coding. How do I merge or update the production one with the informatin from the development one. Cursor has failed at this and I'm a few hours into what seems like a pretty basic request.