systemprompt-cli 0.10.2

Unified CLI for systemprompt.io AI governance: agent orchestration, MCP governance, analytics, profiles, cloud deploy, and self-hosted operations.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118

use clap::Subcommand;

#[derive(Debug, Subcommand)]
pub enum DbCommands {
    #[command(about = "Execute SQL query (read-only)")]
    Query {
        sql: String,
        #[arg(long)]
        limit: Option<u32>,
        #[arg(long)]
        offset: Option<u32>,
        #[arg(long)]
        format: Option<String>,
    },
    #[command(about = "Execute write operation (INSERT, UPDATE, DELETE)")]
    Execute {
        sql: String,
        #[arg(long)]
        format: Option<String>,
    },
    #[command(about = "List all tables with row counts and sizes")]
    Tables {
        #[arg(long, help = "Filter tables by pattern")]
        filter: Option<String>,
    },
    #[command(about = "Describe table schema with columns and indexes")]
    Describe { table_name: String },
    #[command(about = "Show database information")]
    Info,
    #[command(about = "Run database migrations")]
    Migrate {
        #[arg(
            long,
            help = "Continue past migration checksum mismatches with a warning instead of \
                    erroring (use with caution)"
        )]
        allow_checksum_drift: bool,
    },
    #[command(about = "Revert the most recently applied migrations for an extension")]
    MigrateDown {
        #[arg(help = "Extension ID")]
        extension: String,
        #[arg(help = "Number of migrations to revert")]
        count: u32,
    },
    #[command(
        about = "Squash an extension's migrations 1..=N into a baseline at version 0 (dry-run by \
                 default)"
    )]
    MigrateSquash {
        #[arg(long, help = "Extension ID whose migrations should be squashed")]
        extension: String,
        #[arg(
            long,
            help = "Squash migrations with version 1..=through into the baseline"
        )]
        through: u32,
        #[arg(
            long,
            help = "Apply the squash (write baseline file + rewrite DB rows). Without this flag, \
                    the command is a dry-run."
        )]
        apply: bool,
    },
    #[command(about = "Show migration status and history")]
    Migrations {
        #[command(subcommand)]
        cmd: MigrationsCommands,
    },
    #[command(
        about = "Show pending migrations (dry-run / plan, no DB writes)",
        name = "migrate-plan"
    )]
    MigratePlan {
        #[arg(help = "Filter by extension ID (default: all extensions)")]
        extension: Option<String>,
        #[arg(long, help = "Emit JSON instead of a text table")]
        json: bool,
    },
    #[command(
        about = "Detailed introspectable migration status (applied, pending, drift)",
        name = "migrate-status"
    )]
    MigrateStatus {
        #[arg(help = "Filter by extension ID (default: all extensions)")]
        extension: Option<String>,
        #[arg(long, help = "Emit JSON instead of a text table")]
        json: bool,
    },
    #[command(about = "Assign admin role to a user")]
    AssignAdmin { user: String },
    #[command(about = "Show database connection status")]
    Status,
    #[command(about = "Validate database schema against expected tables")]
    Validate,
    #[command(about = "Get row count for a table")]
    Count { table_name: String },
    #[command(about = "List all indexes")]
    Indexes {
        #[arg(long, help = "Filter by table name")]
        table: Option<String>,
    },
    #[command(about = "Show database and table sizes")]
    Size,
    #[command(about = "Diff live schema against extension declarations")]
    Doctor,
}

#[derive(Debug, Subcommand)]
pub enum MigrationsCommands {
    #[command(about = "Show migration status for all extensions")]
    Status,
    #[command(about = "Show migration history for an extension")]
    History {
        #[arg(help = "Extension ID")]
        extension: String,
    },
}