Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

Announcing Declarative Schema, a new way to simplify managing your growing database schema! Declarative schema stores the final state of the database in SQL files, making them the single source of truth. We use it internally to manage our prod db, and we hope you love it too!

Supabase

202,661 subscribers

33,881 views • 1 year ago •via X (Twitter)

News & Politics Science & Technology Education

Anya Rossi• Live Now

Private livecam show

10 Comments

Supabase1 year ago

Blog post: YouTube:

Power Homeschool1 year ago

Our independent, self-paced homeschool program offers flexibility to adapt your child’s coursework to their unique needs. Combined with one-on-one instruction in the comfort of your home, many families enjoy the advantages of homeschooling for their children with special needs.

Anthony Harley1 year ago

@dshukertjr been wanting something like this!

Anthony Spiteri1 year ago

The hand movements of the Supabase Technologists are somewhat... pronounced... anyone else noticed this :)

Kakarot1 year ago

What is it with supabase employees and hand movements?

Kyzo1 year ago

so it's like drizzle but not typesafe?

Jonathan Bangert1 year ago

Woah, this is great!

Choogie1 year ago

This is basically the Prisma file in SQL, right?

Goldkey1 year ago

@dshukertjr newb to db question, but why is it better to store schema as an SQL file rather than say a JSON?

WXTNSS1 year ago

This is great, does anyone have supabase cursor rules for this?

Related Videos

Simplify database management using Declarative Schema! With declarative schema, you can have a single source of truth for the shape of your database in a single file! No more having to go through multiple migration files to figure out the schema of your database!

Simplify database management using Declarative Schema! With declarative schema, you can have a single source of truth for the shape of your database in a single file! No more having to go through multiple migration files to figure out the schema of your database!

Tyler Shukert

14,995 views • 1 year ago

Announcing Realtime Broadcast from Database! Broadcast from Database allows you to broadcast changes happening in your database in a flexible and scalable way. It even supports joining multiple tables to broadcast the payload, opening up new way to listen to database changes!

Announcing Realtime Broadcast from Database! Broadcast from Database allows you to broadcast changes happening in your database in a flexible and scalable way. It even supports joining multiple tables to broadcast the payload, opening up new way to listen to database changes!

Supabase

33,170 views • 1 year ago

You can connect your Supabase database via MCP server to Cursor! The Cursor agent can get the schema and any data from your database through the official Postgres MCP server! This helps Cursor understand your database better when it needs to modify it to add a new feature!

You can connect your Supabase database via MCP server to Cursor! The Cursor agent can get the schema and any data from your database through the official Postgres MCP server! This helps Cursor understand your database better when it needs to modify it to add a new feature!

Tyler Shukert

203,451 views • 1 year ago

Can AI create an app based on the database schema? I connected Supabase with tables to Lovable. Then asked it to create an app based on the schema! The AI picked up my intention and created a social app. With better prompting, this could be a new way of building an app!

Can AI create an app based on the database schema? I connected Supabase with tables to Lovable. Then asked it to create an app based on the schema! The AI picked up my intention and created a social app. With better prompting, this could be a new way of building an app!

Tyler Shukert

36,436 views • 1 year ago

StreamDB - a reactive database in a Durable Stream. Designed for AI apps and agentic session state. You give it a Standard Schema. You get type-safe, multiplexed data sync into TANSTACK DB. Links in the 🧵

StreamDB - a reactive database in a Durable Stream. Designed for AI apps and agentic session state. You give it a Standard Schema. You get type-safe, multiplexed data sync into TANSTACK DB. Links in the 🧵

Electric

21,448 views • 4 months ago

Olive (Olive) is the best way to build internal tools with natural language. It connects to your database, understands your schema, and generates functional tools in minutes. Congrats on the launch, Bardia Safari and Shrey Gupta!

Olive (Olive) is the best way to build internal tools with natural language. It connects to your database, understands your schema, and generates functional tools in minutes. Congrats on the launch, Bardia Safari and Shrey Gupta!

Y Combinator

46,069 views • 1 year ago

We built a SQL and NoSQL co-pilot: Generate an answer with accompanying code by typing a question to ask your database - built in code editor - AI sanity check - schema explorer - shareable perma-links to past queries Join the private beta here:

We built a SQL and NoSQL co-pilot: Generate an answer with accompanying code by typing a question to ask your database - built in code editor - AI sanity check - schema explorer - shareable perma-links to past queries Join the private beta here:

Use Bink

74,965 views • 3 years ago

As part of our effort to move the platform toward declarative code, new tables in the public schema will no longer be automatically exposed to the Data API in new Supabase projects starting May 30th. Instead, tables will need to be explicitly granted each permission to each role, either through the dashboard or via SQL. Explicit Postgres grants are reviewable, diffable, and greppable. They also give you per-role control: anon and authenticated need different privileges in most schemas, and an explicit grant makes that difference visible in your migrations. This was always possible; now it's the default.

As part of our effort to move the platform toward declarative code, new tables in the public schema will no longer be automatically exposed to the Data API in new Supabase projects starting May 30th. Instead, tables will need to be explicitly granted each permission to each role, either through the dashboard or via SQL. Explicit Postgres grants are reviewable, diffable, and greppable. They also give you per-role control: anon and authenticated need different privileges in most schemas, and an explicit grant makes that difference visible in your migrations. This was always possible; now it's the default.

Supabase

40,247 views • 2 months ago

You can now edit your tables from the schema visualizer

You can now edit your tables from the schema visualizer

Supabase

16,248 views • 2 months ago

The future of writing database queries is not writing them at all! MongoDB just released their own MCP Server, and it quietly shifts how we interact with databases. It connects to AI tools like Claude, Cursor, or GitHub Copilot, and you can just talk to your database using natural language: → "What's the schema for the orders collection?" → "Find the top 10 users by purchase volume." → "Create a read-only DB user." No need to context switch. No need to memorize query syntax. No need to even leave your IDE. It works across MongoDB Atlas, Community, and Enterprise, and supports admin ops, schema exploration, indexing, and code generation, all via natural language. This way, you can focus on what actually matters: data modeling, app logic, and product experience. Link to the announcement in the next tweet. Thanks to #MongoDB team for partnering with me today!

The future of writing database queries is not writing them at all! MongoDB just released their own MCP Server, and it quietly shifts how we interact with databases. It connects to AI tools like Claude, Cursor, or GitHub Copilot, and you can just talk to your database using natural language: → "What's the schema for the orders collection?" → "Find the top 10 users by purchase volume." → "Create a read-only DB user." No need to context switch. No need to memorize query syntax. No need to even leave your IDE. It works across MongoDB Atlas, Community, and Enterprise, and supports admin ops, schema exploration, indexing, and code generation, all via natural language. This way, you can focus on what actually matters: data modeling, app logic, and product experience. Link to the announcement in the next tweet. Thanks to #MongoDB team for partnering with me today!

Akshay 🚀

32,084 views • 1 year ago

I’m building an iOS app called Schema, a way to access databases when you’re away from your desk. Schema works with Postgres and MySQL. Here’s a teaser, and I’ll share some of the more clever UI over the coming weeks. I’m growing the size of the TestFlight. Reach out if you’d like access.

I’m building an iOS app called Schema, a way to access databases when you’re away from your desk. Schema works with Postgres and MySQL. Here’s a teaser, and I’ll share some of the more clever UI over the coming weeks. I’m growing the size of the TestFlight. Reach out if you’d like access.

Allan

60,143 views • 1 year ago

🌊TrellisInsights (YC W24) makes unstructured data SQL-ready. It extracts and transforms your unstructured data to SQL-compliant tables with schema you define with natural language. Congrats on the launch, Mac Klinkachorn and Jacky Lin!

🌊TrellisInsights (YC W24) makes unstructured data SQL-ready. It extracts and transforms your unstructured data to SQL-compliant tables with schema you define with natural language. Congrats on the launch, Mac Klinkachorn and Jacky Lin!

Y Combinator

14,213 views • 2 years ago

⏰ we brought time travel to replit! 1. see a global history of all your checkpoints 2. view a fully interactive version of your app at any point in that history 3. rollback and rollforward to any point in history (with your database data and schema, h/t Neon Postgres)

⏰ we brought time travel to replit! 1. see a global history of all your checkpoints 2. view a fully interactive version of your app at any point in that history 3. rollback and rollforward to any point in history (with your database data and schema, h/t Neon Postgres)

Jacky

161,838 views • 1 year ago

English Is The New SQL LLMs have made it easy for everyone to create on-the-fly dashboards and plots. You can connect to your database and then use a SOTA LLM like 4o, Opus, or Gemini to generate SQL and Python code to create on-the-fly dashboards and plots. ChatLLM makes it possible across all state-of-the-art LLMs -

English Is The New SQL LLMs have made it easy for everyone to create on-the-fly dashboards and plots. You can connect to your database and then use a SOTA LLM like 4o, Opus, or Gemini to generate SQL and Python code to create on-the-fly dashboards and plots. ChatLLM makes it possible across all state-of-the-art LLMs -

Bindu Reddy

50,564 views • 2 years ago

Building on Solana just got easier. HyperStack joins your onchain accounts any way you want and streams the data straight to you. Just define a single schema. Our infra does the rest. Join the waitlist 👇

Building on Solana just got easier. HyperStack joins your onchain accounts any way you want and streams the data straight to you. Just define a single schema. Our infra does the rest. Join the waitlist 👇

HyperTek

95,200 views • 9 months ago

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless

"nooo you cant map government spending in a SQL database and allow everyone to use it, you dont have a degree" The beaver builds the dam regardless

Beaver 🦁

86,519 views • 6 months ago

Today at Yoast we’re shipping something I've actually wanted to see on the web for some time (even before working at Yoast) and am now honored to be part of the team to bring this to the masses... Built in collaboration with the Open Source and NLWeb team at Microsoft lead by R.V.Guha (co-creator of RSS, RDF and other web standards) - we're introducing the Schema Aggregation feature: a "schemamap" endpoint that outputs your site's entire structured data map in one place. Under the hood, we now provide a standardised, deduplicated map of your entities via a single endpoint. An agent no longer needs to crawl all individual pages to understand its meaning but can now ingest an entire entity map with ease. A few details to note about the endpoint: - It's is cacheable with sub‑100ms responses - It respects existing privacy and indexing settings - It aggregates all indexable content without navigation noise - It merges duplicate entities so your "Author X" or "Article Y" exist as a single node instead of being re‑discovered on every URL. - If you're using one of our paid plugins that extends schema even more (such as Yoast WooCommerce SEO adds product schema) this will be populated within the endpoint too - If you already extend Yoast’s Schema API, or use partners like events or recipe plugins, their entities are pulled into the same map automatically. For me, this is one of the first major ways the agentic web can ingest a site at scale, and with much more efficiency and context. It has also been so much fun to work with this alongside the team at Yoast, particularly the genius mind of Alain Schlesser. Lastly, we have also launched a schema visualisation tool to view how everything is output. You can enable this feature today with the free version of Yoast SEO.

Today at Yoast we’re shipping something I've actually wanted to see on the web for some time (even before working at Yoast) and am now honored to be part of the team to bring this to the masses... Built in collaboration with the Open Source and NLWeb team at Microsoft lead by R.V.Guha (co-creator of RSS, RDF and other web standards) - we're introducing the Schema Aggregation feature: a "schemamap" endpoint that outputs your site's entire structured data map in one place. Under the hood, we now provide a standardised, deduplicated map of your entities via a single endpoint. An agent no longer needs to crawl all individual pages to understand its meaning but can now ingest an entire entity map with ease. A few details to note about the endpoint: - It's is cacheable with sub‑100ms responses - It respects existing privacy and indexing settings - It aggregates all indexable content without navigation noise - It merges duplicate entities so your "Author X" or "Article Y" exist as a single node instead of being re‑discovered on every URL. - If you're using one of our paid plugins that extends schema even more (such as Yoast WooCommerce SEO adds product schema) this will be populated within the endpoint too - If you already extend Yoast’s Schema API, or use partners like events or recipe plugins, their entities are pulled into the same map automatically. For me, this is one of the first major ways the agentic web can ingest a site at scale, and with much more efficiency and context. It has also been so much fun to work with this alongside the team at Yoast, particularly the genius mind of Alain Schlesser. Lastly, we have also launched a schema visualisation tool to view how everything is output. You can enable this feature today with the free version of Yoast SEO.

Alex Moss

15,360 views • 4 months ago

Agentic Document Extraction now supports field extraction! Many doc extraction use cases extract specific fields from forms and other structured documents. You can now input a picture or PDF of an invoice, request the vendor name, item list, and prices, and get back the extracted fields. Or input a medical form and specify a schema to extract patient name, patient ID, insurance number, etc. One cool feature: If you don't feel like writing a schema (json specification of what fields to extract) yourself, upload one sample document and write a natural language prompt saying what you want, and we automatically generate a schema for you. See the video for details!

Agentic Document Extraction now supports field extraction! Many doc extraction use cases extract specific fields from forms and other structured documents. You can now input a picture or PDF of an invoice, request the vendor name, item list, and prices, and get back the extracted fields. Or input a medical form and specify a schema to extract patient name, patient ID, insurance number, etc. One cool feature: If you don't feel like writing a schema (json specification of what fields to extract) yourself, upload one sample document and write a natural language prompt saying what you want, and we automatically generate a schema for you. See the video for details!

Andrew Ng

193,012 views • 1 year ago

We have improved the SQL editor experience for the local version of Supabase. The SQL snippets will now be stored inside the supabase/snippets directory, which you can commit to git and share across teams, or add them to .gitignore, your choice.

We have improved the SQL editor experience for the local version of Supabase. The SQL snippets will now be stored inside the supabase/snippets directory, which you can commit to git and share across teams, or add them to .gitignore, your choice.

Supabase

14,350 views • 1 month ago