Prisma Cloud Help
Hi there, got interesting question. have migrated my postgres to prisma however i can see the data on the TablePlus but cant retrieve or see it in the prisma studio. even if i add new row it does not show up on the prisma studio nor the query that i sent. how can i resolve this is there anybody seen this error before ?
3 Replies
You opted for speed from this bot. Let's conjure up an answer right now!
It sounds like you’re experiencing an issue where data is visible in TablePlus but not in Prisma Studio or through Prisma queries. This can happen for a few reasons:
1. Wrong Database or Schema: Double-check that your
DATABASE_URL in your .env file matches the database and schema you’re viewing in TablePlus. Prisma Studio and the Prisma Client will only show data from the database/schema specified in this URL. If you have multiple databases or schemas, it’s easy to be connected to the wrong one in Prisma or TablePlus.
2. TCP Tunnel/Connection Issues: If you’re using Prisma Postgres (hosted by Prisma), ensure you’re connecting through the correct TCP tunnel and port. Prisma Studio and your queries must use the same tunnel/connection details as TablePlus. See the docs for connecting with third-party editors.
3. Browser Cache/IndexedDB Issue: Sometimes, Prisma Studio can show no data due to a browser cache or IndexedDB issue. Try clearing your browser’s IndexedDB or use a private/incognito window to see if the data appears. This has resolved similar issues in the past see here.
4. Port Conflict: If Prisma Studio fails to load, ensure no other application (like an emulator) is using port 5555, which Prisma Studio uses by default. Closing the conflicting app can resolve this see here.
5. Migration/Schema Mismatch: If you recently migrated your database, ensure that the Prisma schema matches the actual database schema. Run npx prisma introspect to update your Prisma schema from the database.
If you’ve checked all the above and still have issues, try running a simple query with Prisma Client and compare the results with TablePlus. If the problem persists, please provide more details about your setup and any erro
r messages you see.
Let me know if you need more specific troubleshooting steps!
🤔 Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly.
In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.Can retrive data if i dont use prisma+prosgres/token thing and actual database url string
Do you get any errors in the Prisma Studio?