Fully autonomous AI Agents system capable of performing complex penetration testing tasks
Go ai-agentsai-security-toolanthropicautonomous-agentsgolanggptgraphqlmulti-agent-systemoffensive-securityopen-sourceopenaipenetration-testingpenetration-testing-toolsreactsecurity-automationsecurity-testingsecurity-toolsself-hosted
-- name: GetProviders :many
SELECT
p.*
FROM providers p
WHERE p.deleted_at IS NULL
ORDER BY p.created_at ASC;
-- name: GetProvidersByType :many
SELECT
p.*
FROM providers p
WHERE p.type = $1 AND p.deleted_at IS NULL
ORDER BY p.created_at ASC;
-- name: GetProvider :one
SELECT
p.*
FROM providers p
WHERE p.id = $1 AND p.deleted_at IS NULL;
-- name: GetUserProvider :one
SELECT
p.*
FROM providers p
INNER JOIN users u ON p.user_id = u.id
WHERE p.id = $1 AND p.user_id = $2 AND p.deleted_at IS NULL;
-- name: GetUserProviders :many
SELECT
p.*
FROM providers p
INNER JOIN users u ON p.user_id = u.id
WHERE p.user_id = $1 AND p.deleted_at IS NULL
ORDER BY p.created_at ASC;
-- name: GetUserProvidersByType :many
SELECT
p.*
FROM providers p
INNER JOIN users u ON p.user_id = u.id
WHERE p.user_id = $1 AND p.type = $2 AND p.deleted_at IS NULL
ORDER BY p.created_at ASC;
-- name: GetUserProviderByName :one
SELECT
p.*
FROM providers p
INNER JOIN users u ON p.user_id = u.id
WHERE p.name = $1 AND p.user_id = $2 AND p.deleted_at IS NULL;
-- name: CreateProvider :one
INSERT INTO providers (
user_id,
type,
name,
config
) VALUES (
$1, $2, $3, $4
)
RETURNING *;
-- name: UpdateProvider :one
UPDATE providers
SET config = $2, name = $3
WHERE id = $1
RETURNING *;
-- name: UpdateUserProvider :one
UPDATE providers
SET config = $3, name = $4
WHERE id = $1 AND user_id = $2
RETURNING *;
-- name: DeleteProvider :one
UPDATE providers
SET deleted_at = CURRENT_TIMESTAMP
WHERE id = $1
RETURNING *;
-- name: DeleteUserProvider :one
-- deleted_at IS NULL is load-bearing, not just hygiene: without it a replayed
-- delete of an already-deleted id still succeeds and still returns the row, and
-- the caller then resets every flow/assistant matching that name — which by
-- then may belong to a *different*, live provider reusing the freed name
-- (providers_name_user_id_unique is partial on deleted_at IS NULL). Mirrors the
-- guard GetUserProvider already applies on the rename path.
UPDATE providers
SET deleted_at = CURRENT_TIMESTAMP
WHERE id = $1 AND user_id = $2 AND deleted_at IS NULL
RETURNING *;