Mocks for databases are extremely brittle and complicated. – javcasas Mocks in general are rarely worth it, the DB ones: 10x so. – pdimitar Was dealing with mocking voodoo garbage this morning as a result of fixing a bug. What a horrible mess just to claim a few lines of “test coverage.” – kerblang ...

We keep expanding our Schema Diff feature, this time adding an API endpoint: compare_schema. You can use it in all your Neon projects, including the Free Plan.  Schema Diff allows you to easily compare schemas between Neon databases. It was first made available via the Neon Console and CLI, and we r...

When you’re building an application, you have to map out how your code will travel through the entire software lifecycle—from writing new features to verifying they work correctly before release. Typically, you’re going to need: The problem with persistent environments  To design these non-prod envi...

Neon’s serverless architecture with decoupled storage and compute makes it possible to offer database branching via copy-on-write. This feature is among the most loved by teams using Neon, but if you’ve never seen it in action, it’s hard to visualize how it works or why it’s useful. That’s why we’ve...

We often recommend Hyperdrive to Neon users building on Cloudflare Workers, particularly for global applications looking to reduce latency. But we frequently receive questions about this tool and how it works with Neon—so let’s cover the most common ones in this blog post.  What is Hyperdrive?  Serv...

Amazon RDS has long been the default choice for hosting Postgres in AWS. Its reliability makes it a solid pick for many teams—but as workloads evolve, RDS can start becoming a serious bottleneck. Spotting the signs early can save your team time, money, and headaches. Signs of danger in RDS  Sign 1: ...

The Model Context Protocol (MCP) keeps gaining traction in the AI space, and since the launch of the Neon MCP Server (~2 weeks ago), the community has built dozens of these servers across a wide spectrum of domains. However, the Claude Desktop app has established itself as the default MCP Client, wi...

If you’ve used Replit Agent, you already know it can configure your development environment, build apps, and deploy them to the cloud—all without needing to install anything yourself.  But what you might not know is that Agent can configure databases for you, ensuring your application can store user...

It’s very likely that you, like many developers today, are exploring how to build AI apps using the hottest tools—and one of them is definitely ElevenLabs. That’s why we’ve put together a guide that teaches you how to create an app like this—an AI voice assistant we’ve named Pulse: To try it, Here’s...

“We’re a small team, but we’re scaling quickly and doing a lot. We’re shipping multiple times a day— to do that, we need to test stuff quickly and merge to main very quickly as well. Neon branches are a game changer for this.” (Avi Romanoff, Founder at Magic Circle) Magic Circle is a new game […]

If you’ve ever worked with Postgres, you’ve probably launched psql at least once. It’s the default database client packaged with the Postgres server. This is a command-line application, written in C, and it’s packed with many features such as autocompletion, command history, and data export/import. ...

1989. The year the Berners-Lee proposed the World Wide Web, The Simpsons first premiered, and Taylor Swift was born. Another worldwide phenom was born that year: Microsoft SQL Server 1.0.  We’ve had 35 years of SQL Server (Microsoft’s version), and if you’ve been invested in the MS ecosystem, SQL Se...

This blog post teaches you an easy method to implement row-level security in your Postgres database when using AWS Cognito for authorization. To demonstrate everything, we’ll be using an app with Neon as the Postgres provider, Neon Authorize, Express.js, and HTMX. All the code in this post can be fo...

Our collaboration with Microsoft continues to grow. Last August, we announced a strategic investment from M12, Microsoft’s venture fund, with a goal to bring Neon closer into the Azure ecosystem. Today, we’re excited to introduce Neon as an Azure Native Integration, allowing developers to provision ...

Anthropic recently introduced an open protocol to enable LLMs to more easily integrate with external data sources and tools. Model Context Protocol can thus be used to expose all kinds of products and services to LLMs and agents alike. We’re excited to announce that we’ve already created a MCP serve...

AWS Lambda is pretty awesome. Serverless “Functions as a Service” where you can deploy code without worrying about servers, scaling, or infra. Well, that’s the dream. The reality can be a bit nearer earth, especially when Lambda bumps up against other services, say databases. This isn’t Lambda’s fau...

We recently launched Neon RLS to simplify Postgres authorization with row-level security.  If you’ve been reading our posts, tutorials, or READMEs on the subject, you’ll have come across three little letters: JWT. This whole world seems to run on JWTs–so what are they? JWTs, or JSON Web Tokens to gi...

We just launched the Schema Diff GitHub Action, a tool that simplifies schema migrations by automatically tracking schema changes as a comment in your pull requests. Check out our docs for step-by-step instructions to get started. Neon branches are great for many things, but testing schema changes h...

At Neon, security is at the core of everything we do. Our serverless platform was built with a vision for innovation, but we also know that a commitment to security is paramount. That’s why we’re excited to announce the launch of our Neon’s Bug Bounty Program in partnership with HackerOne. We’ve des...

In this blog post, we’ll explain how you can use a combination of DrizzleORM, GitHub Actions, the Neon API, and a couple of custom template scripts to manage multiple databases using the same database schema. You can find all the code referenced in this blog post on this repo: https://github.com/neo...

Starting December 1st, many Neon users will see lower storage costs. Inactive branches—those idle for at least a day and older than 2 weeks—will now be charged at a reduced per-GB rate. If this applies to you, there’s nothing you need to do—it all happens automatically. Simply enjoy the savings.  He...

The Neon Console is a Single Page Application (SPA), or rather, a collection of SPAs. Static assets like JavaScript and CSS are served through CloudFront, while the HTML is dynamically rendered by our Go backend. In this post, we’ll dive into our journey of migrating from webpack to Vite, the challe...

A common SaaS pattern involves deploying a single application environment shared among all users. However, RAG presents additional reliability and security challenges, relying heavily on user-provided information and unpredictable model APIs. This article covers a multi-tenant RAG pipeline example (...

In Neon, we recommend using a project-per-user pattern for multitenancy whenever possible. If this doesn’t work for you and you’re placing all your tenants within a single Postgres database, you should at least use RLS to prevent cross-tenant access—but expressing your entire authorization model wit...

A few weeks ago, we participated in a panel talking about AI Agents with Wordware. For those of you who prefer to scroll through it, here’s a summary of our conversation—plus a Wordware demo. The interlocutors in this conversation were Raouf Chebri, Sr Developer Advocate at Neon (asking the question...

Postgres Row-Level Security is notoriously difficult to comprehend and use. The policy access model for a todos table in a Todo List app can be declared as per the following table: Operation Using(applies to data being returned) Wich Check(applies to data being written) Select auth.user_id() = user_...

We keep working on improving observability for Neon users. A first big step came with the launch of our monitoring dashboard, and to continue checking boxes, we’re now launching an integration with Datadog so you can track essential metrics from your Neon databases directly in the Datadog platform. ...

Postgres’s Row-Level Security feature allows us to set up the access rules for our data. In other words, it can be used to declare the authorization model for an application or a service. As I’ve been trying to better understand RLS and its pros and cons, I decided to work on an RLS-backed authoriza...

Replit Agent is a powerful tool within the Replit development environment that allows you to offload coding tasks using natural language and AI. By interacting with the Replit Agent, you can generate code, create applications, and modify existing features simply by asking for what you need.  This au...

I’ve worked on apps with a “SQL from the client” architecture and the development velocity was simply superb. At the same time, it comes with a lot of challenges in terms of security and scalability. So, what’s the deal? Is it viable or not? The tl;dr is that the technology is perhaps not ready yet,...