SQLRPA — AI Powered DBA

Open Beta

SQLRPA

SQL Robotic Process Automation

A governance-first SQL automation and risk scoring toolkit. Built for DBAs who need AI assistance without sacrificing control, auditability, or production stability.

Request Beta Access View on GitHub → See the Framework

sqlrpa_risk_assess.sql

-- SQLRPA v1.0 · Risk Assessment Module

-- Governance-first · Advisory mode only

EXEC sqlrpa.assess_deployment_risk

@change_script = 'ALTER TABLE dbo.Orders

ADD COLUMN total_tax DECIMAL(10,2)',

@target_env = 'PROD',

@peak_window_check = 1,

@advisory_only = 1;

/* Advisory Output */

risk_tier HIGH

risk_score 84 / 100

table_row_count 142,847,293

lock_risk TABLE LOCK · est. 4-8 min

peak_conflict YES · current window

advisory Defer to maintenance window

rec_window Sun 02:00–04:00 UTC

authorization HUMAN_REQUIRED

-- No action taken. Awaiting DBA authorization.

What SQLRPA is

✅A deployment risk scoring engine for SQL Server schema changes

✅A query anomaly detection tool that surfaces unusual patterns for DBA review

✅An advisory system that generates recommendations — never executes autonomously

✅A governance layer that logs every AI suggestion and authorization decision

✅A pipeline integration tool that gates deployments on risk score thresholds

✅A capacity forecasting module for 60–180 day infrastructure planning

What SQLRPA is not

🚫An autonomous database management tool that operates without human oversight

🚫A replacement for a skilled DBA — it augments judgment, doesn't replace it

🚫An AI that writes and executes production queries without authorization

🚫A black-box system — every output is explainable and traceable

🚫A tool that requires cloud connectivity or external data transmission

🚫A one-size-fits-all solution — thresholds and rules are fully configurable

Core Modules

Everything in the toolkit.

⚡

Deployment Risk Scoring

Scores every schema change against table size, peak traffic windows, lock risk, and historical incident patterns. Returns a 0–100 score with a tiered classification and advisory rationale.

🔍

Query Anomaly Detection

Establishes behavioral baselines and surfaces queries deviating from normal patterns — execution time spikes, unusual scan ratios, new table access patterns, parameter sniffing symptoms.

🛡

Governance & Audit Trail

Logs every advisory output, authorization decision, and executed action. Tamper-evident, queryable, and exportable for change control and compliance reporting.

🔁

CI/CD Pipeline Gate

PowerShell and YAML modules for Azure DevOps, GitHub Actions, and Jenkins. Risk score gates block HIGH and CRITICAL deployments from promoting to production.

📈

Capacity Forecasting

Builds 60, 90, and 180-day projections for storage, IOPS, CPU, and memory from your DMV data. Includes seasonal pattern weighting and confidence intervals.

⚙️

Configuration Engine

All thresholds, risk weights, alert rules, and governance policies are defined in versioned config files. Environment-specific profiles for dev, staging, and production.

Compatibility

Works with your existing stack.

🗄️

SQL Server

2016, 2017, 2019, 2022

☁️

Azure SQL

Managed Instance & Database

🟠

AWS RDS

SQL Server on RDS

🔁

CI/CD

Azure DevOps · GitHub Actions · Jenkins

🛡

Governance-first by design — not as a feature.

SQLRPA was built from the ground up with enterprise governance requirements in mind. The audit trail, authorization workflow, and least-privilege access model aren't optional add-ons — they're the foundation the entire toolkit is built on. If it can't be governed and audited, it doesn't ship.

Beta Access

Join the beta.

SQLRPA is currently in open beta. Beta access includes the full toolkit, documentation, SQL scripts, YAML pipeline modules, and direct feedback access to the author.

Request Beta Access

Drop your email and I'll send you access details, setup docs, and the GitHub repo invite.

No spam. Beta access only. I'll follow up personally.

View on GitHub → Need a guided deployment?

The framework behind
SQLRPA is in the books.

Both editions cover the full architecture — why it's built this way, how to customize it for your environment, and the governance model that makes it safe for enterprise production use.

Get the Books → Book a Consulting Call

Also in the books

→Full SQL scripts for every SQLRPA module

→YAML pipeline configurations for CI/CD

→Governance template library

→Risk scoring calibration guide

→Production deployment playbook