Database consulting that makes your PostgreSQL schema, migrations and access rules safe to change
Database consulting reviews and fixes how an application stores, protects and changes its data: schema, migrations, access rules, performance and backups. Goldenroz focuses on PostgreSQL and Supabase, where Shai, our CTO, runs a production database of about 145 tables with Row Level Security. Projects start at $25,000 at a fixed price per phase after a free one-hour scoping call.
From $25,000, fixed price per phase
Updated 2026-11-14. By Shai Goldenberg
What usually goes wrong
- Queries that slowed as tables grewPages that loaded instantly at launch now time out. Indexes were never revisited, and an ORM hides what is sent to the database.
- Migrations the team is afraid ofA schema change once locked a busy table in the middle of the day. Since then changes are batched, delayed and applied by hand.
- Tenants separated only in application codeOne missing filter in one endpoint shows a customer another customer's records.
- Open permissions left by a fast buildTables created by an app builder or an AI agent have row level security switched off, or policies that allow every caller.
- Money stored as editable balancesBalances are updated in place with no ledger. A retry or a race condition creates or destroys funds, and nothing detects it.
What is included
- Database reviewA read of the schema, slow queries, indexes, policies, functions, roles and backup setup, with findings ranked by severity and a fixed price for fixes.
- Schema and index workConstraints, foreign keys and indexes matched to the queries the application runs, checked with query plans before and after.
- Migration pipelineSchema changes in version control, checked in CI and run on staging first, with a plan for changes that would lock large tables.
- Row Level Security and tenant isolationPolicies written and tested per table, with isolation enforced in the database so one application bug cannot cross tenants.
- Backup and restore testPoint-in-time recovery settings reviewed and a restore run to a separate database, with the time it took recorded.
- Monitoring and handoverAlerts for disk, connections, replication lag and slow queries, and a written guide for your engineers.
PostgreSQL consulting and Supabase consulting: the record behind it
PostgreSQL consulting is the part of this page with evidence. Shai's main production project has about 145 tables with Row Level Security and 155 policies, tenant isolation enforced in database triggers and about 440 migrations applied through CI. Payments run on a double-entry, append-only ledger with idempotency keys and automated conservation checks.
Supabase consulting applies the same habits to teams on that platform: policies reviewed table by table, functions checked for what an anonymous caller can reach, and a daily automated probe that calls sensitive functions as an anonymous user and closes open permissions. Guard hooks in the pipeline block two SQL patterns that caused real incidents. For a wider review that includes application code, see the code and security audit.
Database migration services, administration and data engineering: where the limits are
Database migration services cover moving a PostgreSQL database between hosts or providers, upgrading major versions and moving from another engine to PostgreSQL. The plan includes a rehearsal on a copy, a replication or dump-and-restore method chosen by size and allowed downtime, checks that row counts and totals match, and a rollback step.
Database administration services in the ongoing sense, including remote DBA services with someone on call, are not part of this project work. PostgreSQL support after handover can be arranged under the managed IT services retainer, with coverage hours defined in the agreement. Data engineering services such as warehouses and large analytics pipelines are outside our evidenced record, and we say so on the scoping call. The pipeline side of schema changes is part of DevOps consulting.
How the work runs
Scoping call
Before the projectA free one-hour call with Shai about how you release today, what has broken, and what you want to stop worrying about.
Delivery review
Week 1We read the repository, the pipeline, the environments and recent incidents, and write a ranked list of changes with a fixed price.
Pipeline and environments
First phaseCI checks, staging and production separation and automated deploys. The team starts releasing through the pipeline during this phase.
Observability and guardrails
Second phaseAlerts, dashboards, scheduled probes and review hooks, tuned so that an alert means something.
Handover
Final weekRunbooks, a recorded walkthrough and a session where your engineers run a release and a rollback themselves.
What it costs
Each phase has a fixed scope and price, agreed after the delivery review. Cloud, hosting and tool subscriptions are paid directly by you.
- CI/CD, environments and observability projectFixed price per phaseFrom $25,000
- Kubernetes, cloud migration or cloud cost workFixed price per phase after a review, from $25,000Scoped per project
- Larger platform programsSeveral phases$100,000 and up
- Scoping callOne hour with Shai$0
Who it is not for
- Buyers who need a certified Oracle or Microsoft SQL Server specialist.
- Data warehouse, business intelligence and machine learning pipeline projects.
- Budgets under $25,000.
Who does the work
Shai leads the technology side: business software, SaaS and mobile apps, payments and escrow systems, Postgres security, AI agents built with Claude Code and MCP, and IT and infrastructure projects with senior infrastructure engineers.
Questions buyers ask
What does database consulting include?
At Goldenroz it includes a review of schema, queries, policies and backups, followed by fixed-price phases for index and schema work, a migration pipeline, row level security and a restore test. Fixes are delivered as pull requests in your repository. The work ends with a written guide and a handover.
How much does database consulting cost?
Projects start at $25,000 at a fixed price per phase, quoted after a free one-hour scoping call and the review. Larger programs, such as a migration between engines, run $100,000 and up. Hosting and database fees are paid by you to the provider. See pricing.
Do you work with databases other than PostgreSQL?
Our evidenced record is PostgreSQL and Supabase. For MySQL, SQL Server, Oracle or MongoDB we do not claim production experience, and on the scoping call we say whether the specific task is one we can take on well.
Do you offer remote DBA services or PostgreSQL support on a retainer?
Not as a standalone on-call DBA. Ongoing database care can be included in a monthly retainer quoted after an assessment, with coverage hours and response times written into the agreement. We make no round-the-clock promise on this page.
Can you fix row level security on a Supabase project built quickly?
Yes. We list every table and function, test what an anonymous and a signed-in user can read and write, and deliver corrected policies as pull requests. A scheduled probe is left running so that a new table without policies is caught.
Guides on this topic
- Kubernetes solves real problems for teams with many services and uneven load. Use this eight-question test to see if you need it, and what to run if you do not.
- Compare the four ways to modernize a legacy system: rehost, refactor, rebuild or replace. See what each fixes, what it leaves, and how to migrate in phases.
- What an employee self-service (ESS) portal should include, which HR, payroll and IT systems it connects to, and how to phase the build without a big launch.
Talk to the person who will do the work
One hour, no sales team. You talk to Shai Goldenberg, the CTO, about your systems or your product, and you leave with a clear next step and a price range.