Connects to the tools you use
Set up connections through ERP.AI and Proto workflows, with every change logged.
- Database Administration
- Backup execution system
- Monitoring source
- Event provider
- Identity source
Database Administration brings a database instance, its host asset, service and responsible person into the same operating record. The team can follow backup runs by database and distinguish a completed run from one with recorded restore-test evidence.
Backup runs in one list
| Run number | Database | Started at | Completed at | Restore test at | Status | |
|---|---|---|---|---|---|---|
| BR-22321 | shipments_prod on tracking host | 22 Oct | 23 Oct | 01 Nov | Completed | |
| BR-68424 | orders_replica on east standby | 27 Oct | 23 Oct | 31 Oct | Completed | |
| BR-86737 | inventory_reporting on west host | 04 Nov | 23 Oct | 29 Oct | Completed | |
| BR-91901 | orders_replica on east standby | 19 Oct | 20 Oct | 24 Oct | Completed | |
| BR-47444 | orders_prod on east primary | 16 Oct | 20 Oct | 27 Oct | Completed |
Change Approver decides whether the reviewed service change may proceed.
Every feature works on the same records. Pick one to see the screen your team works in.
Connect each database to its host asset and accountable owner.
Database instances
| Database name | Engine | Version | Asset | Owner | |
|---|---|---|---|---|---|
| orders_prod on east primary | Relational SQL engine | Relational SQL engine 16.4 | Primary database host, east cluster | Amina Duarte | |
| orders_replica on east standby | Transactional SQL engine | Transactional SQL engine 11.4 | Supplier portal database host | Ravi Nair | |
| billing_prod on ledger host | Enterprise SQL engine | SQL Server 2022 | Warehouse query node 03 | Luis Romero | |
| inventory_reporting on west host | Web SQL engine | Web SQL engine 8.4 | Replica host, east cluster | Ravi Nair | |
| identity_prod on directory host | Document database engine | Document database engine 7.0 | Primary database host, east cluster | Luis Romero |
Review backup outcomes and recorded restore-test evidence by database.
Backup runs
| Run number | Database | Started at | Completed at | Status | |
|---|---|---|---|---|---|
| BR-84158 | shipments_prod on tracking host | 04 Nov | Failed | ||
| BR-40221 | orders_replica on east standby | 29 Oct | Failed | ||
| BR-72741 | identity_prod on directory host | 26 Oct | Failed | ||
| BR-43090 | analytics_dw on query node | 18 Oct | Failed | ||
| BR-20390 | supplier_portal_prod on portal host | 27 Oct | Failed |
Assign service incidents and retain acknowledgment and investigation updates.
Incidents
| Summary | Service | Asset | Opened at | Acknowledged at | Status | |
|---|---|---|---|---|---|---|
| Patch orders primary after failover | Billing ledger database | Directory database host | 21 Oct | 22 Oct | Open | |
| Investigate billing query slowdown | Shipment tracking database | Replica host, east cluster | 24 Oct | 23 Oct | Acknowledged | |
| Restore missing replica WAL segment | Billing ledger database | Warehouse query node 03 | 11 Oct | 14 Oct | Investigating | |
| Expand reporting storage volume | Supplier portal database | Replica host, east cluster | 15 Oct | 17 Oct | Resolved | |
| Rotate directory credentials | Inventory reporting service | Reporting host, west cluster | 27 Oct | 23 Oct | Closed |
Review risk, planned work and rollback before a service change proceeds.
Approval conditions
| Summary | Risk | Service | Scheduled start | Scheduled end | Rollback plan | |
|---|---|---|---|---|---|---|
| Patch orders primary after failover | Low | Billing ledger database | 29 Oct | 06 Nov | Restore previous schema migration | |
| Investigate billing query slowdown | Medium | Shipment tracking database | 18 Oct | 21 Oct | Fail back to healthy replica | |
| Restore missing replica WAL segment | High | Identity directory database | 25 Oct | 31 Oct | Restore last verified snapshot | |
| Expand reporting storage volume | Low | Supplier portal database | 24 Oct | 31 Oct | Reduce volume to prior allocation | |
| Rotate directory credentials | Medium | Shipment tracking database | 15 Oct | 21 Oct | Reinstate prior credential |
Route a service request through approval and recorded completion.
Approval conditions
| Request number | Request type | Requester | Service | Requested at | Due at | |
|---|---|---|---|---|---|---|
| SR-92050 | Database restore | Sofia Bennett | Supplier portal database | 25 Oct | 30 Oct | |
| SR-26355 | User access change | Ravi Nair | Billing ledger database | 26 Oct | 03 Nov | |
| SR-15302 | Storage expansion | Amina Duarte | Customer orders database | 26 Oct | 30 Oct | |
| SR-31540 | Read replica creation | Sofia Bennett | Analytics warehouse | 24 Oct | 31 Oct | |
| SR-21130 | Schema migration | Ravi Nair | Inventory reporting service | 23 Oct | 26 Oct |
Keep service ownership, recurring problems and incoming event receipts visible.
Changes
| Summary | Service | Risk | Scheduled start | Scheduled end | Status | |
|---|---|---|---|---|---|---|
| Patch orders primary after failover | Shipment tracking database | Low | 26 Oct | 28 Oct | Approved | |
| Investigate billing query slowdown | Shipment tracking database | Medium | 24 Oct | 01 Nov | Implementing | |
| Restore missing replica WAL segment | Supplier portal database | High | 28 Oct | 05 Nov | Approved | |
| Expand reporting storage volume | Analytics warehouse | Low | 01 Nov | 03 Nov | Implementing | |
| Rotate directory credentials | Customer orders database | Medium | 03 Nov | 09 Nov | Approved |
Database record to verified change ships ready to use. One step needs a named approval before the work moves on: Review Change (Change Approver).
Connect the database to its host asset and owner.
Capture the run outcome against the right database.
Review the restore-test date for the completed run.
Have the Change Approver decide on risk, timing and rollback.
Carry out approved service work in its planned window.
Record the outcome after the work or rollback.
Open any backup run to see the roles that work on it, its process stages and its approvals on one page.
Started at, Completed at and Restore test at.
Records linked to this backup run.
Admin, Database Administrator and Backup Reviewer, each with their own permissions.
Every status change, in order.
Review Change, with who decides.
Completed
Change review and request approval have different owners and working records.
Signed in as Change Approver
| Decision | Approver | |
|---|---|---|
| Review ChangeHave the Change Approver decide on risk, timing and rollback. | Change Approver | |
| Approve Changes | Change Approver | |
| Approve service requests | Request Approver |
Everyone opens Database Administration to the work that is theirs. Pick a role to see what it starts with.
Maintains access and reference records across database operations.
Owns database instance details and records backup work against the right instance.
This is the first screen this role sees.
Changes · Database Administrator
| Summary | Service | Risk | Scheduled start | Scheduled end | Status | |
|---|---|---|---|---|---|---|
| Patch orders primary after failover | Shipment tracking database | Low | 26 Oct | 28 Oct | Approved | |
| Investigate billing query slowdown | Shipment tracking database | Medium | 24 Oct | 01 Nov | Implementing | |
| Restore missing replica WAL segment | Supplier portal database | High | 28 Oct | 05 Nov | Approved | |
| Expand reporting storage volume | Analytics warehouse | Low | 01 Nov | 03 Nov | Implementing | |
| Rotate directory credentials | Customer orders database | Medium | 03 Nov | 09 Nov | Approved |
Checks backup outcomes and recorded restore-test evidence.
This is the first screen this role sees.
Backup runs · Backup Reviewer
| Run number | Database | Started at | Completed at | Restore test at | Status | |
|---|---|---|---|---|---|---|
| BR-22321 | shipments_prod on tracking host | 22 Oct | 23 Oct | 01 Nov | Completed | |
| BR-68424 | orders_replica on east standby | 27 Oct | 23 Oct | 31 Oct | Completed | |
| BR-86737 | inventory_reporting on west host | 04 Nov | 23 Oct | 29 Oct | Completed | |
| BR-91901 | orders_replica on east standby | 19 Oct | 20 Oct | 24 Oct | Completed | |
| BR-47444 | orders_prod on east primary | 16 Oct | 20 Oct | 27 Oct | Completed |
Takes responsibility for incidents and records investigation updates.
This is the first screen this role sees.
Incidents · Incident Responder
Reviews change risk, schedule and rollback plan before implementation.
This is the first screen this role sees.
Changes · Change Approver
| Summary | Service | Risk | Scheduled start | Scheduled end | Status | |
|---|---|---|---|---|---|---|
| Patch orders primary after failover | Shipment tracking database | Low | 26 Oct | 28 Oct | Approved | |
| Investigate billing query slowdown | Shipment tracking database | Medium | 24 Oct | 01 Nov | Implementing | |
| Restore missing replica WAL segment | Supplier portal database | High | 28 Oct | 05 Nov | Approved | |
| Expand reporting storage volume | Analytics warehouse | Low | 01 Nov | 03 Nov | Implementing | |
| Rotate directory credentials | Customer orders database | Medium | 03 Nov | 09 Nov | Approved |
Decides whether submitted service requests can proceed.
This is the first screen this role sees.
Service requests · Request Approver
| Request number | Request type | Requester | Service | Requested at | Due at | |
|---|---|---|---|---|---|---|
| SR-92050 | Database restore | Sofia Bennett | Supplier portal database | 25 Oct | 30 Oct | |
| SR-26355 | User access change | Ravi Nair | Billing ledger database | 26 Oct | 03 Nov | |
| SR-15302 | Storage expansion | Amina Duarte | Customer orders database | 26 Oct | 30 Oct | |
| SR-31540 | Read replica creation | Sofia Bennett | Analytics warehouse | 24 Oct | 31 Oct | |
| SR-21130 | Schema migration | Ravi Nair | Inventory reporting service | 23 Oct | 26 Oct |
Owns service context, recurring problems and incoming integration receipts.
This is the first screen this role sees.
Changes · Service Manager
| Summary | Service | Risk | Scheduled start | Scheduled end | Status | |
|---|---|---|---|---|---|---|
| Patch orders primary after failover | Shipment tracking database | Low | 26 Oct | 28 Oct | Approved | |
| Investigate billing query slowdown | Shipment tracking database | Medium | 24 Oct | 01 Nov | Implementing | |
| Restore missing replica WAL segment | Supplier portal database | High | 28 Oct | 05 Nov | Approved | |
| Expand reporting storage volume | Analytics warehouse | Low | 01 Nov | 03 Nov | Implementing | |
| Rotate directory credentials | Customer orders database | Medium | 03 Nov | 09 Nov | Approved |
Answer operational questions from database, service and work records.
This quarter
How far records got this quarter
| Stage | Reached | Step | |
|---|---|---|---|
| Running | 39 | ||
| Completed | 9 | 23% | |
| Failed | 2 | 22% | |
| Verified | 1 | 50% |
Sample counts per stage
Which databases have failed runs or a completed run awaiting evidence review?
Compare recorded start and completion times for backup runs.
Which services carry active, high-priority incident work?
Compare opening and acknowledgment times for recorded incidents.
Which planned service changes were approved, rejected or rolled back?
Which service requests are still active and when did completed work finish?
See current problem status and assigned owner.
Which provider events failed or were rejected during processing?
See how Database Administration fits your kind of team.
Each stage of database record to verified change names the role that acts and the status it records, so a change is never anonymous.
Each stage, the role that acts and the status it records
Ask Proto to prepare records and explain the next operational step.
Set up connections through ERP.AI and Proto workflows, with every change logged.
Every record lives in a table you can see, extend and export. Add fields or whole tables in Proto.
Browse all 12 tablesStart with one team and one process, then add the rest once the basics are running.
Add users, people and services with clear owners and criticality.
Connect assets to services and database instances to assets and people.
Record a representative backup run and check its database, outcome and restore-test date.
Open an incident, review a change and approve a submitted request with the people who will own those decisions.
Bring external events and operational signals into the corresponding records and inspect failed receipts.
$0per user
The base account and everyday work in the ERP.AI app are free, for every user.
| Usage | Per $1 |
|---|---|
| Record reads (list, filter, get) | 20,000 |
| Search or aggregate queries | 4,000 |
| Record writes | 4,000 |
| Imported or synced records | 200,000 |
| Workflow runs | 2,000 |
| AI agent runs | 2,000 |
| Scheduled jobs or webhooks | 20,000 |
| File uploads (MB) | 2,000 |
| CSV or PDF exports | 100 |
Click Get started, then use Proto to configure Database Administration for your business. Begin with a service, its host asset, a database instance and a recent backup run. Rehearse a review and an incident before expanding the scope.
Each backup run references a database instance. That instance references a host asset and an owner.
A run can be completed before it is verified. Check the restore-test evidence before recording its date; a completed run with that evidence moves to verified.
The Change Approver reviews the service, risk, planned window and rollback plan, then records approval or rejection.
The incident records its service, asset and assigned person. The newly opened incident receives an acknowledgment time; the responder records authored updates as work proceeds.
A problem record can retain the statement, owner, root cause and investigation status under the affected service.
The Request Approver decides on submitted work. Approved requests can then move into progress and completion.
It records the provider, external event identity, receipt time, payload hash and processing outcome for reconciliation.
Confirm service names, host asset tags and the person who responds to incidents so incoming signals can be mapped to the right operational context.
Start free, then use Proto to change fields, steps and approvals before your team goes live.