Loading video...

Video Failed to Load

Go Home

๐Ÿ†• Introducing PrismaGPT, a query helper built on GPT-4 ๐ŸŽ‰ * Drop in your Prisma schema * Ask for what you want * Get back a Prisma Client query and raw SQL Great for when you know what you need but aren't quite sure how to construct the query ๐Ÿ‘

ryanchenkie's profile picture

Ryan Chenkie

10,899 subscribers

94,195 views โ€ข 3 years ago โ€ขvia X (Twitter)

Science & TechnologyNews & PoliticsEducation
LIVE

Anya Rossiโ€ข Live Now

Private livecam show

10 Comments

Matija Sosic's profile picture
Matija Sosic3 years ago

@prisma nice one! If you're looking for an OSS template to build sth similar, we just released one yesterday (React/Node/Prisma + GPT integration): It already got >100โญ๏ธ on gh!

Tim Petri's profile picture
Tim Petri3 years ago

@prisma This would be awesome as a vs code extension instead of a website where I have to upload (and reupload) my schema.

Ryan Chenkie's profile picture
Ryan Chenkie3 years ago

@prisma VS Code extension would be cool. I'll look into that. I'll also add something to keep the schema in local storage.

Manish Dalal's profile picture
Manish Dalal3 years ago

@prisma Have a look at use gpt to create schema, build query and generate CRUD query code!

Alex Ruheni's profile picture
Alex Ruheni3 years ago

@prisma This looks really awesome @ryanchenkie! ๐ŸŽ‰ Would you like to join us tomorrow on "What's New In Prisma" to showcase PrismaGPT?

Theral Moyo's profile picture
Theral Moyo3 years ago

@prisma This is so sick, will be featuring it in my AI newsletter tomorrow. Getting sent to 4000 people

Ryan Chenkie's profile picture
Ryan Chenkie3 years ago

@prisma Many thanks!

Jan Wilhelm's profile picture
Jan Wilhelm3 years ago

@prisma If you are using Metabase and want a similar SQL-generating feature, have a look at @AvantyApp

Mike @ HTML All The Things ๐Ÿ‡จ๐Ÿ‡ฆ's profile picture
Mike @ HTML All The Things ๐Ÿ‡จ๐Ÿ‡ฆ3 years ago

@prisma This is awesome! Love that it gives both Prisma client and SQL. Probably going to use that with planetscale's database.js lib.

Jens Neuse | Founder @ WunderGraph's profile picture
Jens Neuse | Founder @ WunderGraph3 years ago

@prisma The next step is to ask GPT to just generate code that does what you need, without an ORM. ๐Ÿ˜…

Related Videos

Can adding an index bring down the cost of that SQL query from $0.00000208 to $0.00000018? And how would you know? Aurora DSQL's new EXPLAIN ANALYZE VERBOSE feature tells you exactly how much a SQL query costs to run, so you can see exactly how tuning efforts affect your cost.
0:50

Can adding an index bring down the cost of that SQL query from $0.00000208 to $0.00000018? And how would you know? Aurora DSQL's new EXPLAIN ANALYZE VERBOSE feature tells you exactly how much a SQL query costs to run, so you can see exactly how tuning efforts affect your cost.

Marc Brooker

47,031 views โ€ข 8 months ago

Quick demo of Zeroโ€™s new background queries. Zeroโ€™s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. Itโ€™s important to realize Zero isnโ€™t really a cache. Itโ€™s a replica. Itโ€™s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing โ€œbackโ€. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.
1:01

Quick demo of Zeroโ€™s new background queries. Zeroโ€™s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. Itโ€™s important to realize Zero isnโ€™t really a cache. Itโ€™s a replica. Itโ€™s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing โ€œbackโ€. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.

Aaron Boodman

18,808 views โ€ข 1 year ago

PEOPLE OF THE EARTH. Figured out how to ask natural language questions of current financial data and get back a natural language response...with correct/relevant numbers! ๐Ÿคฏ๐Ÿ’ฐโœจ So. Freaking. Cool. 1. Send database schema along with the question and relevant scope/parameters to GPT. 2. GPT returns SQL query. 3. Run SQL query on your data. 4. Take returned data and pass it in along with the original question. 5. GPT returns natural language answer with relevant data! Original Question: What was the highest price of Apple's stock over the past decade and how does it compare to Tesla's highest stock price? And on what date were those highest prices? Final Answer: The highest price of Apple's stock over the past decade was $182.94 on January 4, 2022, while Tesla's highest stock price was $414.50 on November 4, 2021.
3:23

PEOPLE OF THE EARTH. Figured out how to ask natural language questions of current financial data and get back a natural language response...with correct/relevant numbers! ๐Ÿคฏ๐Ÿ’ฐโœจ So. Freaking. Cool. 1. Send database schema along with the question and relevant scope/parameters to GPT. 2. GPT returns SQL query. 3. Run SQL query on your data. 4. Take returned data and pass it in along with the original question. 5. GPT returns natural language answer with relevant data! Original Question: What was the highest price of Apple's stock over the past decade and how does it compare to Tesla's highest stock price? And on what date were those highest prices? Final Answer: The highest price of Apple's stock over the past decade was $182.94 on January 4, 2022, while Tesla's highest stock price was $414.50 on November 4, 2021.

Josh Pigford

245,304 views โ€ข 3 years ago

There are 5 million oil and gas wells across the US - but you want to know what's going on in your area. AI helps you cut through the noise. Draw a shape on the map, query the wells - AI tells you who's operating, what they're drilling, how deep they're going.
1:17

There are 5 million oil and gas wells across the US - but you want to know what's going on in your area. AI helps you cut through the noise. Draw a shape on the map, query the wells - AI tells you who's operating, what they're drilling, how deep they're going.

Kyle Walker

23,174 views โ€ข 6 months ago

When CBI gives a green light to charge sheet you in cash-for-query scam but you have already married a senior advocate for this day Then you at your wedding reception ๐Ÿ˜‚:
2:10

When CBI gives a green light to charge sheet you in cash-for-query scam but you have already married a senior advocate for this day Then you at your wedding reception ๐Ÿ˜‚:

Monica Verma

40,826 views โ€ข 8 months ago

Have you ever been frustrated trying to find relevant web results for complex search queries? Introducing Deep Search, a new Bing feature which leverages GPT-4 to expand your query into many variations and multiple probable intents, so that you can find highly relevant results.
0:26

Have you ever been frustrated trying to find relevant web results for complex search queries? Introducing Deep Search, a new Bing feature which leverages GPT-4 to expand your query into many variations and multiple probable intents, so that you can find highly relevant results.

Jordi Ribas

23,613 views โ€ข 2 years ago

Your agents can't keep up with real-time data. Especially when it's scattered across dozens of sources. Most teams waste weeks building custom connectors for every database, API, and data warehouse. Then they build ETL pipelines to sync everything. By the time your agent retrieves the data, it's already outdated. Picture this: Your Postgres database updated 5 minutes ago. Your MongoDB collection changed 2 minutes ago. Your agent is still pulling from yesterday's snapshot. This is why most production RAG systems fail. There's a better approach: MindsDB is an open-source AI platform with a federated data engine that lets you query multiple data sources in real-time using SQL - without moving any data. Here's what makes it different: โ†ณ Your data stays in place. No ETL pipelines or data duplication โ†ณ Query Postgres, MongoDB, REST APIs, and more using consistent SQL โ†ณ JOIN across different sources in real-time with a unified interface โ†ณ Works with both structured and un-structured data And here's the best part: You don't even need to write SQL. Just describe what you want in plain English, and MindsDB converts it to SQL automatically. The system does all the heavy lifting. The breakthrough for AI agents is simple: When data updates at the source, your agent gets fresh results immediately. No sync delays. No stale embeddings. No custom code for each integration. You can literally write a SQL query that joins a Postgres table with a MongoDB collection and gets live results. This is what production AI applications need but rarely get. In this video, I give you a complete walkthrough of what we just discussed and how to actually do it. Make sure you watch this till the end. I've shared the link to MindsDB's GitHub repo in the next tweet!
9:28

Your agents can't keep up with real-time data. Especially when it's scattered across dozens of sources. Most teams waste weeks building custom connectors for every database, API, and data warehouse. Then they build ETL pipelines to sync everything. By the time your agent retrieves the data, it's already outdated. Picture this: Your Postgres database updated 5 minutes ago. Your MongoDB collection changed 2 minutes ago. Your agent is still pulling from yesterday's snapshot. This is why most production RAG systems fail. There's a better approach: MindsDB is an open-source AI platform with a federated data engine that lets you query multiple data sources in real-time using SQL - without moving any data. Here's what makes it different: โ†ณ Your data stays in place. No ETL pipelines or data duplication โ†ณ Query Postgres, MongoDB, REST APIs, and more using consistent SQL โ†ณ JOIN across different sources in real-time with a unified interface โ†ณ Works with both structured and un-structured data And here's the best part: You don't even need to write SQL. Just describe what you want in plain English, and MindsDB converts it to SQL automatically. The system does all the heavy lifting. The breakthrough for AI agents is simple: When data updates at the source, your agent gets fresh results immediately. No sync delays. No stale embeddings. No custom code for each integration. You can literally write a SQL query that joins a Postgres table with a MongoDB collection and gets live results. This is what production AI applications need but rarely get. In this video, I give you a complete walkthrough of what we just discussed and how to actually do it. Make sure you watch this till the end. I've shared the link to MindsDB's GitHub repo in the next tweet!

Akshay ๐Ÿš€

65,672 views โ€ข 9 months ago

"When you know exactly what you want and aren't afraid to ask for it. ๐Ÿ’…โœจ ๐ŸŽฌFoolsRushIn"
0:58

"When you know exactly what you want and aren't afraid to ask for it. ๐Ÿ’…โœจ ๐ŸŽฌFoolsRushIn"

HIL~LARY

130,006 views โ€ข 2 months ago

This Python script helps you better understand how embeddings work for SEO. Input a sentence + a query and BERT will calculate a content "Similarity Score": Search engines use embedding models to translate your content into numeric values. This is how they're able to mathematically determine whether a page on your site is actually relevant to a query someone is searching for. Once both the content and query are run through embeddings - they can calculate the "cosine similarity" or how similar the two entities are to each one. With this Python script, you can actually visualize how cosine similarity works for yourself. To you use you'll simply: 1. Save the Python script to a text file 2. Use your Terminal to run the script 3. You'll be prompted for both a "Sentence" and "Query" 4. Once entered, the script will calculate a "Similarity Score" between the text and query. This is how relevant your sentence is for the target keyword. By running this, you'll see that search engines are able to come with an calculation of content relevance. You'll need to think about the content on your site the same way - which sections have high scores and which ones have low ones? I've linked the Python script in the comments below. No coding knowledge is required and it walks you step by step on how to implement it.
2:37

This Python script helps you better understand how embeddings work for SEO. Input a sentence + a query and BERT will calculate a content "Similarity Score": Search engines use embedding models to translate your content into numeric values. This is how they're able to mathematically determine whether a page on your site is actually relevant to a query someone is searching for. Once both the content and query are run through embeddings - they can calculate the "cosine similarity" or how similar the two entities are to each one. With this Python script, you can actually visualize how cosine similarity works for yourself. To you use you'll simply: 1. Save the Python script to a text file 2. Use your Terminal to run the script 3. You'll be prompted for both a "Sentence" and "Query" 4. Once entered, the script will calculate a "Similarity Score" between the text and query. This is how relevant your sentence is for the target keyword. By running this, you'll see that search engines are able to come with an calculation of content relevance. You'll need to think about the content on your site the same way - which sections have high scores and which ones have low ones? I've linked the Python script in the comments below. No coding knowledge is required and it walks you step by step on how to implement it.

Chris Long

13,185 views โ€ข 2 years ago

DeFi data just became model-ready. Introducing Query Builder for DefiLlama Sheets. Instead of writing complex formulas or stitching together multiple queries, you can now pull exactly the data you want into Sheets or Excel in a few clicks. > Build spreadsheet formulas visually > Query multiple projects in a single request > Analyze historical metrics side by side with clean, consistent data
0:52

DeFi data just became model-ready. Introducing Query Builder for DefiLlama Sheets. Instead of writing complex formulas or stitching together multiple queries, you can now pull exactly the data you want into Sheets or Excel in a few clicks. > Build spreadsheet formulas visually > Query multiple projects in a single request > Analyze historical metrics side by side with clean, consistent data

DefiLlama.com

21,665 views โ€ข 6 months ago

๐Ÿ’ก CSS Tip! A small tool to create a quantity query selector using has(). Adjust the setting and get your selector in no time! ๐Ÿ˜Ž I am trying a new kind of "interactive CSS Tip". Let me know what you think. Link in the reply ๐Ÿ‘‡
0:34

๐Ÿ’ก CSS Tip! A small tool to create a quantity query selector using has(). Adjust the setting and get your selector in no time! ๐Ÿ˜Ž I am trying a new kind of "interactive CSS Tip". Let me know what you think. Link in the reply ๐Ÿ‘‡

CSS by T. Afif

19,823 views โ€ข 1 year ago

My website is almost complete. You enter any baseball savant search query and it will collect all the videos from that query and combine them into one video for you to download. Here's a test example. It was made in less than 1 minute with just 2 clicks of a button
6:40

My website is almost complete. You enter any baseball savant search query and it will collect all the videos from that query and combine them into one video for you to download. Here's a test example. It was made in less than 1 minute with just 2 clicks of a button

Vinnie

306,541 views โ€ข 1 year ago

"what time is the debate" query on google is a deep commentary on state of internet .. most obvious one box ever answer, but instead pages and pages of SEO optimized crap that hides the answer you obviously want
0:40

"what time is the debate" query on google is a deep commentary on state of internet .. most obvious one box ever answer, but instead pages and pages of SEO optimized crap that hides the answer you obviously want

sam lessin ๐Ÿดโ€โ˜ ๏ธ

562,164 views โ€ข 1 year ago

Available to everyone: The new analytics lets you query your data directly from a report in real time using ShopifyQL, for more dynamic and customizable reporting. Everyone has a data warehouse now!
0:20

Available to everyone: The new analytics lets you query your data directly from a report in real time using ShopifyQL, for more dynamic and customizable reporting. Everyone has a data warehouse now!

tobi lutke

12,139 views โ€ข 1 year ago

Does your team rely on Snowflake or BigQuery as your data warehouse? We built the step that every other onchain data provider skips. Transform first, deliver only what you need. dbt Connector โ†’ Datashare is now live. Query against 130+ chains โžก๏ธ Transform with dbt on DuneSQL โžก๏ธ Deliver only what you need to your warehouse One contract. Any dataset. Any transformation.
1:08

Does your team rely on Snowflake or BigQuery as your data warehouse? We built the step that every other onchain data provider skips. Transform first, deliver only what you need. dbt Connector โ†’ Datashare is now live. Query against 130+ chains โžก๏ธ Transform with dbt on DuneSQL โžก๏ธ Deliver only what you need to your warehouse One contract. Any dataset. Any transformation.

Dune

31,177 views โ€ข 4 months ago

Meet Waldo: Gleanโ€™s first agentic search model. Built on NVIDIA Nemotron 3 Nano and post-trained for search planning, Waldo figures out how to break down a query, which tools to call, what to read next, and when it has enough evidence to hand off.
0:50

Meet Waldo: Gleanโ€™s first agentic search model. Built on NVIDIA Nemotron 3 Nano and post-trained for search planning, Waldo figures out how to break down a query, which tools to call, what to read next, and when it has enough evidence to hand off.

Glean

98,637 views โ€ข 3 months ago

Introducing DeadSubs - You can just take over a dead subreddit. Find Dead and Inactive subreddits eligible for takeover with DeadSubs. Here is how to use it. > Enter query/keywords you are looking for > AI will generate suggested keywords > Search for Dead Subreddits > Follow the Reddit official process to make it yours. > Boost your Reddit Marketing. Start for free!
0:48

Introducing DeadSubs - You can just take over a dead subreddit. Find Dead and Inactive subreddits eligible for takeover with DeadSubs. Here is how to use it. > Enter query/keywords you are looking for > AI will generate suggested keywords > Search for Dead Subreddits > Follow the Reddit official process to make it yours. > Boost your Reddit Marketing. Start for free!

Manoj Ahirwar

11,298 views โ€ข 3 months ago

We can finally say it! is launching today! We spent a year building the data substrate for the agent economy, one MCP that allows your agents to query the world as a DB, so you can skip the data and focus on building what matters! Cala
1:36

We can finally say it! is launching today! We spent a year building the data substrate for the agent economy, one MCP that allows your agents to query the world as a DB, so you can skip the data and focus on building what matters! Cala

Elisenda Bou-Balust

18,688 views โ€ข 3 months ago

Here's what happens when you query an Ethereum balance on the Internet Computer: "3 out of 4" consensus mode Responses must match or you get an error Pay in cycles (like gas) - no API keys, no credit cards Add Bitcoin to Ethereum and Solana, and you've got TRUE multi-chain DeFi.
1:30

Here's what happens when you query an Ethereum balance on the Internet Computer: "3 out of 4" consensus mode Responses must match or you get an error Pay in cycles (like gas) - no API keys, no credit cards Add Bitcoin to Ethereum and Solana, and you've got TRUE multi-chain DeFi.

DFINITY Foundation

19,290 views โ€ข 9 months ago