Skip to content

Changelog

What changed in Backenly, newest first. Where the code is open, each change links to the pull requests behind it.

Showing all 56 changes

November 2026

15 changes: 4 new, 8 improved, 3 fixed

NewFunctions

Sign users in from a function

A function that verifies a user its own way, with an SMS code or another identity provider, can now sign them in: call createSession(userId), or ctx.auth.createSession(userId) in a sandboxed function. Backenly signs the session, and the token is the same one password sign-in issues, valid for seven days.

#780 on GitHub (opens in a new tab)

Sign a user in
// An http function
import { createSession } from '@/lib/auth/session'

// Call it only after your own check has passed,
// such as a code sent by SMS.
const { token, user } = await createSession(userId)

// A sandboxed function
const session = await ctx.auth.createSession(userId)
ImprovedAutonomy

Index repairs no longer block writes

Backenly builds its index repairs with CREATE INDEX CONCURRENTLY on a separate connection, so writes keep flowing. Autopilot also builds indexes for queries PostgreSQL measured as slow, and partitioning advice appears only for tables larger than the database’s cache.

#651 on GitHub (opens in a new tab)#652 on GitHub (opens in a new tab)#675 on GitHub (opens in a new tab)

Rows read to find one movie's watchlist entries

watchlist_items, from Postgres's own table statistics

Rows read to find one movie's watchlist entries, per minute. At 03:06 a check found no index on watchlist_items.movie_id; at 03:07 Backenly added it on its own; at 03:08 it was re-checked and all 27 checks passed. At 03:12 your agent's request to drop a column on movies waited for you.
MinuteRows readChecks
03:054,120all 27 checks pass
03:064,12026 of 27 checks pass
03:073index added, re-checked next minute
03:083all 27 checks pass
03:093all 27 checks pass
03:103all 27 checks pass
03:113all 27 checks pass
03:123all 27 checks pass; one request waiting on you
03:133all 27 checks pass
03:143all 27 checks pass
03:153all 27 checks pass
03:163all 27 checks pass
03:173all 27 checks pass
ImprovedMCP and agents

A lighter tool list for agents

The tool list an agent session starts with is 36% smaller for read-write keys and 31% smaller for read-only keys. Each tool now states its required arguments, which actions wait for approval and which docs topic to read.

#766 on GitHub (opens in a new tab)

ImprovedDatabase

Merge cards show what changes in production

A branch merge card says what the merge will do to production’s rows, and a merge that would fail on them is refused before anyone is asked to approve it. Branches carry production’s foreign keys, renamed columns show as renames, and an agent can discard its own preview branch.

#661 on GitHub (opens in a new tab)#663 on GitHub (opens in a new tab)#729 on GitHub (opens in a new tab)#665 on GitHub (opens in a new tab)#735 on GitHub (opens in a new tab)

ImprovedPlatform

API errors say what went wrong

Every v1 error has a top-level code and message, and /api/v2 errors use PostgREST’s shape. A refusal names its cause, such as row-level security, a value of the wrong type or a body over the size limit, and an unknown field in a query body gets a 400 instead of being ignored.

#747 on GitHub (opens in a new tab)#723 on GitHub (opens in a new tab)#681 on GitHub (opens in a new tab)#682 on GitHub (opens in a new tab)#684 on GitHub (opens in a new tab)#642 on GitHub (opens in a new tab)

ImprovedConsole

New Autonomy and History pages

Autonomy has a Review-only or Autopilot switch in its header, and every row is titled in words with at most two buttons. History groups changes by day and shows whether a person, your agent or Backenly made each one.

#588 on GitHub (opens in a new tab)

ImprovedPlatform

Cloud AI runs on Claude Opus 4.6

Backend chat, autonomy investigations and support answers on Backenly Cloud run on Claude Opus 4.6, through Amazon Bedrock.

#587 on GitHub (opens in a new tab)

Also this month

  • Approve several of an agent’s waiting requests at once, from cards that say what approving does.
  • Realtime sends a large row change with its primary key, and no longer drops events in a burst.
  • A browser key’s rate limit applies to each visitor separately: 300 requests every 10 seconds by default.
  • on_signup functions also fire for Google, GitHub and magic-link sign-ups.
  • The portable export keeps row-level security policies.

October 2026

15 changes: 10 new, 5 improved

NewPlatform

One History for every change

History lists every change, from your agent, Backenly or a person, across schema, auth, storage, functions, integrations, webhooks, environment and API keys. Restore one change, or everything after a point, on every plan; restore points are kept 7 days on Free, 30 on Pro and 90 on Enterprise.

#545 on GitHub (opens in a new tab)#556 on GitHub (opens in a new tab)

Changes to movie-reviews today

Newest first, from the project's History

  1. Claude Code

  2. You, approving Claude Code’s request

    Restored by you at 12:15

    runtime is back with its 1,284 values.

    The 4 movies added since have no runtime.

    The posters bucket, created after it, stays.

  3. Backenly autonomy

Every step, as recorded

Removed column runtime from movies

You, approving Claude Code’s request

  1. Checkpoint taken
  2. Applied
  3. Verified
  4. Restore started
  5. Restore verified

Choose any change to read its steps.

Removed column runtime from movies: Checkpoint taken at 09:14:06, Applied at 09:14:06, Verified at 09:14:07, Restore started at 12:15:40, Restore verified at 12:15:41.

NewAutonomy

Restructure a table with one approval

When columns that belong in a table of their own grow inside another, such as refund_* on orders, Backenly can move them out without breaking existing clients. It rehearses on a copy, asks you once, makes the change in steps and never drops the old columns itself.

#519 on GitHub (opens in a new tab)#559 on GitHub (opens in a new tab)#560 on GitHub (opens in a new tab)

reviews9,431 rows
id
movie_id
user_id
rating
body
flagged_at
flag_reason
moderated_by

Each mark is a sample row. These three are filled in together.

review_moderationplanned
review_id
flagged_at
flag_reason
moderated_by

Your apps read and write it now. The reviews table keeps working too.

Waiting on you

Move moderation data out of reviews into its own table

Changes to these three columns locked all of reviews 5 times in the last 30 days.

30 days on: changes to these columns locked reviews 0 times, down from 5. It helped.

  1. Rehearsed on a copy of reviews, then rolled back
  2. Set up review_moderation
  3. Keep it in step with reviews
  4. Copy the existing moderation data
  5. Check that it matches reviews
  6. Open it to your apps

Agents can read this plan. Only a person can approve it.

ImprovedMCP and agents

backend_chat keeps working after the call returns

A backend_chat request can run for up to ten minutes. The call waits up to 45 seconds, then returns what has landed so far with status running, and backend_chat status collects the rest. It also builds up to about six tables per response instead of planning first.

#567 on GitHub (opens in a new tab)

ImprovedBilling

Payment emails are receipts

The email for a plan payment is now a receipt: the amount, the payment method, the billing period and the invoice.

#561 on GitHub (opens in a new tab)

NewDatabase

An interactive schema diagram

The Database page draws your schema as a diagram with foreign-key lines, a focus view of one table’s relationships, search, a minimap and full screen.

#439 on GitHub (opens in a new tab)

NewDatabase

Every schema change gets a checkpoint

Every production schema change, from an agent, the console, a branch merge or self-healing, takes a checkpoint and runs a verification the caller cannot weaken. A failed change rolls itself back when nothing would be lost, otherwise a person decides, and dropped tables and columns are kept so the change can be restored.

#461 on GitHub (opens in a new tab)

NewPlatform

Five regions to choose from

Create a project in Mumbai, N. Virginia, Oregon, Frankfurt or Singapore. Its database, files, snapshots, function logs and agent conversations stay in that region, and Connect and Settings show that region’s API address.

#341 on GitHub (opens in a new tab)#396 on GitHub (opens in a new tab)#395 on GitHub (opens in a new tab)#410 on GitHub (opens in a new tab)#411 on GitHub (opens in a new tab)#416 on GitHub (opens in a new tab)#417 on GitHub (opens in a new tab)

NewConsole

A support center in the console

Open a support case from the console with a category, a severity and, if you like, the project it is about, then follow it as a thread.

#319 on GitHub (opens in a new tab)

ImprovedDatabase

Preview branches with their own endpoint

Each preview branch has its own endpoint, key and test users, and its traffic stays out of production’s monitoring and autonomy. Agents build on a branch with apply_migration { branchId }, and a merge replays the branch’s migrations on production after a person approves.

#193 on GitHub (opens in a new tab)#194 on GitHub (opens in a new tab)#195 on GitHub (opens in a new tab)#197 on GitHub (opens in a new tab)#203 on GitHub (opens in a new tab)

ImprovedBilling

No cap on API requests

No plan limits API requests, so Free no longer stops at 100,000 in total. Free stays bounded by monthly active users, database size, file storage, egress, function runs and AI credits.

#204 on GitHub (opens in a new tab)

NewBilling

Backenly for Startups

Startups can apply for free Pro at /startups/apply by confirming a work email at their company’s domain. The founding team reviews every application, and an approved pass moves the account to Pro and ends on its own.

#189 on GitHub (opens in a new tab)

ImprovedConsole

A redesigned console

The console is rebuilt on one design system: hairline borders, sentence-case headings and status shown as a coloured dot beside its text. Members, Billing and the organization switcher share the same frame.

#184 on GitHub (opens in a new tab)

Also this month

  • An agent’s deploy rollback asks a project admin to approve the restore it would run.
  • Connect gives one install command per coding agent, and adds Antigravity.
  • The startup pass is now three months of Pro, up from two.
  • New Cloud accounts get a welcome email, and the critical-issue email says why each issue is waiting for you.
  • Foreign keys from apply_migration keep their declared column, name and ON DELETE rule, and cron ranges such as 1-5 fire on every day in the range.

September 2026

15 changes: 12 new, 2 improved, 1 fixed

NewSelf-hosting

Self-host with one command

npm run selfhost takes a fresh clone to a ready deployment, filling in missing secrets without rotating existing ones. Running it again upgrades the deployment through its migrations.

#49 on GitHub (opens in a new tab)#69 on GitHub (opens in a new tab)

Self-hosted install
git clone https://github.com/backenly/backenly.git
cd backenly
npm install
npm run selfhost
NewSelf-hosting

Keep snapshots in S3

Set BACKUP_S3_BUCKET to store project snapshots in S3. Each snapshot is checked by checksum on upload and on restore, and is deleted with its project.

#179 on GitHub (opens in a new tab)

NewBilling

Pay for Pro with Stripe

Pro checkout runs on Stripe, and Stripe’s customer portal handles your payment method and invoices. A cancelled plan stays on Pro until the end of the period you paid for.

#162 on GitHub (opens in a new tab)

FixedDatabase

apply_migration stops guessing

apply_migration refuses CREATE TABLE on a table that already exists, with TABLE_EXISTS, and no longer creates a missing table on ALTER TABLE. ADD COLUMN keeps the NOT NULL, DEFAULT, UNIQUE and REFERENCES it declares.

#134 on GitHub (opens in a new tab)

NewMCP and agents

An MCP tool for each console section

Agents get auth, storage, functions, realtime, integrations, monitoring, autonomy, webhooks, deploy and connect tools. Each runs the same operation and permission check as the console, and a call held for approval runs exactly as requested once a person approves it.

#119 on GitHub (opens in a new tab)#125 on GitHub (opens in a new tab)

ImprovedMCP and agents

MCP server 0.4.0

The remote endpoint and @backenly/mcp-server 0.4.0 run on the official MCP SDK and serve hosts on older and current versions of the protocol, with the same results over stdio and remote. The package needs Node.js 20 or newer.

#130 on GitHub (opens in a new tab)

NewPlatform

Email codes for sign-up and password reset

Signing up to Backenly with an email and password confirms the address with a six-digit code before the account exists. Password reset uses a code too, and now works for accounts created with Google or GitHub.

#102 on GitHub (opens in a new tab)

NewPlatform

Webhooks for row changes and sign-ups

Webhook endpoints receive row.inserted, row.updated, row.deleted and auth.user.created events. Row changes are captured in the database, so writes through the data API trigger them too, and every delivery is signed and retried.

#64 on GitHub (opens in a new tab)

NewDatabase

Snapshots and recovery

Database → Snapshots takes and restores one project’s tables, rows, indexes, constraints and row-level security policies. A self-hosted deployment can export everything from Settings → Recovery and restore it with npm run recovery -- restore.

#63 on GitHub (opens in a new tab)

NewAuth

Send auth email through your own SMTP

A project can send its users’ email through its own SMTP server and replace any built-in template. The settings show the result of the last real send, and Send test reports your provider’s reply.

#66 on GitHub (opens in a new tab)

NewDatabase

Extensions and custom types

Install allowlisted PostgreSQL extensions from the Database page, or get the exact command where the database does not allow it. Create enums and domains; each type lists the columns that use it and cannot be dropped while any do.

#68 on GitHub (opens in a new tab)

NewDatabase

A read-only SQL workspace

The Database page has a SQL workspace that runs every query as the project’s read-only role, inside a read-only transaction. It says when results are truncated and names any columns it redacted.

#51 on GitHub (opens in a new tab)

NewSelf-hosting

Self-host Backenly for one project

Without Cloud configuration, Backenly runs single-tenant: one deployment serving one project. npm run bootstrap provisions it and, when rerun, completes only what is missing, and the web and runtime servers build as containers.

Also this month

  • New API keys start with proj_live_, svc_live_, mcp_live_ or dk_admin_; older sk_ keys keep working.
  • Daily project backups run on Backenly Cloud.
  • A fresh self-hosted deployment is claimed from the sign-up page with its setup token.
  • The project console works on phone screens.

August 2026

11 changes: 7 new, 3 improved, 1 fixed

ImprovedAutonomy

Self-healing every minute, on every plan

The repair loop, the contract sweep and the infrastructure scan now run every minute on every plan. The sweep had run every 15 minutes and the scan once a day, so a fixed problem could stay listed for up to 24 hours.

One hour of checks on one project60 min

Contract sweep

BeforeEvery 15 minutes
NowEvery minute

Infrastructure scan

BeforeOnce a day
NowEvery minute
NewAutonomy

Undo for automatic fixes

Fixes Backenly applied on its own show an Undo button wherever they can be reverted, and undoing a change to row-level security asks you to confirm twice. Each fix records the exact SQL it ran, with a copy button in the Changes panel.

ImprovedAutonomy

Foreign keys and index drops wait for you

Backenly asks before adding a missing foreign key, naming the target table and the exact ON DELETE rule, instead of adding one with CASCADE itself. It reports an index only after 14 days without a scan, and drops it only when you approve.

NewAutonomy

Repairs for bloat and failed migrations

Backenly rebuilds bloated indexes with REINDEX CONCURRENTLY and runs VACUUM ANALYZE where autovacuum has fallen behind. It also finds an unfinished concurrent index or a constraint left NOT VALID by a failed migration, fixes each with one approval, and reports abandoned prepared transactions.

NewAutonomy

Each backend measured against itself

Every hour, Backenly records query latency, sequential scans, table size and connections for each project. When one moves well away from its two-week median, it reports the numbers and what changed just before, and never fixes these findings on its own.

NewMCP and agents

Connect an agent by signing in

The remote MCP endpoint supports OAuth, so a host that supports it opens your browser to sign in instead of needing a key pasted into a config file. The consent screen starts with read-only selected.

NewMCP and agents

Read-only keys for agents

An MCP key can be issued read-only: its agent is offered only read tools, every write is refused with READ_ONLY_KEY, and backend_chat is withheld. A key’s mode is fixed when it is issued.

ImprovedDatabase

Branches as isolated test environments

A branch gets its own sequences and production’s row-level security policies, and starts without production data unless you ask for a copy. An API key bound to a branch sends its requests there.

NewAutonomy

Indexes for the columns slow queries filter on

Backenly reads slow queries from pg_stat_statements, checks the filtered column against the catalog and creates the index, and only advises when it cannot verify the column. New checks flag optional foreign keys the data says are required, unique columns without a constraint, enums kept as free text and money stored as a float.

NewPlatform

Responses say which layer decided them

Data API responses carry x-backenly-request-id and x-backenly-layer headers, naming the layer behind the result: client, auth, api, database or platform. An empty result from a table with row-level security, read without a user’s token, is attributed to auth.

FixedDatabase

Generated tables accept the rows they need

Tables Backenly generates no longer make every column NOT NULL. A column is required only when it is a primary key, a foreign key, an email or a username, or when you ask.

Also this month

  • Backenly no longer reports its own internal tables as findings.
  • Connection health is reported per project instead of for the whole database server.
  • generate_function over MCP draws AI credits for each call.