# 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 grew:** Pages 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 of:** A 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 code:** One missing filter in one endpoint shows a customer another customer's records.
- **Open permissions left by a fast build:** Tables 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 balances:** Balances 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 review:** A 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 work:** Constraints, foreign keys and indexes matched to the queries the application runs, checked with query plans before and after.
- **Migration pipeline:** Schema 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 isolation:** Policies written and tested per table, with isolation enforced in the database so one application bug cannot cross tenants.
- **Backup and restore test:** Point-in-time recovery settings reviewed and a restore run to a separate database, with the time it took recorded.
- **Monitoring and handover:** Alerts 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](https://goldenroz.com/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](https://goldenroz.com/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](https://goldenroz.com/devops-consulting/).

## 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 project: From $25,000 (Fixed price per phase)
- Kubernetes, cloud migration or cloud cost work: Scoped per project (Fixed price per phase after a review, from $25,000)
- Larger platform programs: $100,000 and up (Several phases)
- Scoping call: $0 (One hour with Shai)

## 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.

## 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](https://goldenroz.com/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.

---
Page: https://goldenroz.com/database-consulting/
Book a free one-hour call: https://calendly.com/daniarozin/daniel-rozin-consultation-1-hour-clone
