pgcli Agent Skills & AI Rules

{
    "keywords": {
        "ACCESS": [],
        "ADD": [],
        "ALL": [],
        "ALTER": [
            "AGGREGATE",
            "COLLATION",
            "COLUMN",
            "CONVERSION",
            "DATABASE",
            "DEFAULT",
            "DOMAIN",
            "EVENT TRIGGER",
            "EXTENSION",
            "FOREIGN",
            "FUNCTION",
            "GROUP",
            "INDEX",
            "LANGUAGE",
            "LARGE OBJECT",
            "MATERIALIZED VIEW",
            "OPERATOR",
            "POLICY",
            "ROLE",
            "RULE",
            "SCHEMA",
            "SEQUENCE",
            "SERVER",
            "SYSTEM",
            "TABLE",
            "TABLESPACE",
            "TEXT SEARCH",
            "TRIGGER",
            "TYPE",
            "USER",
            "VIEW"
        ],
        "AND": [],
        "ANY": [],
        "AS": [],
        "ASC": [],
        "AUDIT": [],
        "BEGIN": [],
        "BETWEEN": [],
        "BY": [],
        "CASE": [],
        "CHAR": [],
        "CHECK": [],
        "CLUSTER": [],
        "COLUMN": [],
        "COMMENT": [],
        "COMMIT": [],
        "COMPRESS": [],
        "CONCURRENTLY": [],
        "CONNECT": [],
        "COPY": [],
        "CREATE": [
            "ACCESS METHOD",
            "AGGREGATE",
            "CAST",
            "COLLATION",
            "CONVERSION",
            "DATABASE",
            "DOMAIN",
            "EVENT TRIGGER",
            "EXTENSION",
            "FOREIGN DATA WRAPPER",
            "FOREIGN EXTENSION",
            "FUNCTION",
            "GLOBAL",
            "GROUP",
            "IF NOT EXISTS",
            "INDEX",
            "LANGUAGE",
            "LOCAL",
            "MATERIALIZED VIEW",
            "OPERATOR",
            "OR REPLACE",
            "POLICY",
            "ROLE",
            "RULE",
            "SCHEMA",
            "SEQUENCE",
            "SERVER",
            "TABLE",
            "TABLESPACE",
            "TEMPORARY",
            "TEXT SEARCH",
            "TRIGGER",
            "TYPE",
            "UNIQUE",
            "UNLOGGED",
            "USER",
            "USER MAPPING",
            "VIEW"
        ],
        "CURRENT": [],
        "DATABASE": [],
        "DATE": [],
        "DECIMAL": [],
        "DEFAULT": [],
        "DELETE FROM": [],
        "DELIMITER": [],
        "DESC": [],
        "DESCRIBE": [],
        "DISTINCT": [],
        "DROP": [
            "ACCESS METHOD",
            "AGGREGATE",
            "CAST",
            "COLLATION",
            "COLUMN",
            "CONVERSION",
            "DATABASE",
            "DOMAIN",
            "EVENT TRIGGER",
            "EXTENSION",
            "FOREIGN DATA WRAPPER",
            "FOREIGN TABLE",
            "FUNCTION",
            "GROUP",
            "INDEX",
            "LANGUAGE",
            "MATERIALIZED VIEW",
            "OPERATOR",
            "OWNED",
            "POLICY",
            "ROLE",
            "RULE",
            "SCHEMA",
            "SEQUENCE",
            "SERVER",
            "TABLE",
            "TABLESPACE",
            "TEXT SEARCH",
            "TRANSFORM",
            "TRIGGER",
            "TYPE",
            "USER",
            "USER MAPPING",
            "VIEW"
        ],
        "EXPLAIN": [],
        "ELSE": [],
        "ENCODING": [],
        "ESCAPE": [],
        "EXCLUSIVE": [],
        "EXISTS": [],
        "EXTENSION": [],
        "FILE": [],
        "FLOAT": [],
        "FOR": [],
        "FORMAT": [],
        "FORCE_QUOTE": [],
        "FORCE_NOT_NULL": [],
        "FREEZE": [],
        "FROM": [],
        "FULL": [],
        "FUNCTION": [],
        "GRANT": [],
        "GROUP BY": [],
        "HAVING": [],
        "HEADER": [],
        "IDENTIFIED": [],
        "IMMEDIATE": [],
        "IN": [],
        "INCREMENT": [],
        "INDEX": [],
        "INITIAL": [],
        "INSERT INTO": [],
        "INTEGER": [],
        "INTERSECT": [],
        "INTERVAL": [],
        "INTO": [],
        "IS": [],
        "JOIN": [],
        "LANGUAGE": [],
        "LEFT": [],
        "LEVEL": [],
        "LIKE": [],
        "LIMIT": [],
        "LOCK": [],
        "LONG": [],
        "MATERIALIZED VIEW": [],
        "MAXEXTENTS": [],
        "MINUS": [],
        "MLSLABEL": [],
        "MODE": [],
        "MODIFY": [],
        "NOT": [],
        "NOAUDIT": [],
        "NOTICE": [],
        "NOCOMPRESS": [],
        "NOWAIT": [],
        "NULL": [],
        "NUMBER": [],
        "OIDS": [],
        "OF": [],
        "OFFLINE": [],
        "ON": [],
        "ONLINE": [],
        "OPTION": [],
        "OR": [],
        "ORDER BY": [],
        "OUTER": [],
        "OWNER": [],
        "PCTFREE": [],
        "PRIMARY": [],
        "PRIOR": [],
        "PRIVILEGES": [],
        "QUOTE": [],
        "RAISE": [],
        "RENAME": [],
        "REPLACE": [],
        "RESET": ["ALL"],
        "RAW": [],
        "REFRESH MATERIALIZED VIEW": [],
        "RESOURCE": [],
        "RETURNS": [],
        "REVOKE": [],
        "RIGHT": [],
        "ROLLBACK": [],
        "ROW": [],
        "ROWID": [],
        "ROWNUM": [],
        "ROWS": [],
        "SELECT": [],
        "SESSION": [],
        "SET": ["SEARCH_PATH TO"],
        "SHARE": [],
        "SHOW": [],
        "SIZE": [],
        "SMALLINT": [],
        "START": [],
        "SUCCESSFUL": [],
        "SYNONYM": [],
        "SYSDATE": [],
        "TABLE": [],
        "TEMPLATE": [],
        "THEN": [],
        "TO": [],
        "TRIGGER": [],
        "TRUNCATE": [],
        "UID": [],
        "UNION": [],
        "UNIQUE": [],
        "UPDATE": [],
        "USE": [],
        "USER": [],
        "USING": [],
        "VALIDATE": [],
        "VALUES": [],
        "VARCHAR": [],
        "VARCHAR2": [],
        "VIEW": [],
        "WHEN": [],
        "WHENEVER": [],
        "WHERE": [],
        "WITH": []
    },
    "functions": [
        "ABBREV",
        "ABS",
        "AGE",
        "AREA",
        "ARRAY_AGG",
        "ARRAY_APPEND",
        "ARRAY_CAT",
        "ARRAY_DIMS",
        "ARRAY_FILL",
        "ARRAY_LENGTH",
        "ARRAY_LOWER",
        "ARRAY_NDIMS",
        "ARRAY_POSITION",
        "ARRAY_POSITIONS",
        "ARRAY_PREPEND",
        "ARRAY_REMOVE",
        "ARRAY_REPLACE",
        "ARRAY_TO_STRING",
        "ARRAY_UPPER",
        "ASCII",
        "AVG",
        "BIT_AND",
        "BIT_LENGTH",
        "BIT_OR",
        "BOOL_AND",
        "BOOL_OR",
        "BOUND_BOX",
        "BOX",
        "BROADCAST",
        "BTRIM",
        "CARDINALITY",
        "CBRT",
        "CEIL",
        "CEILING",
        "CENTER",
        "CHAR_LENGTH",
        "CHR",
        "CIRCLE",
        "CLOCK_TIMESTAMP",
        "CONCAT",
        "CONCAT_WS",
        "CONVERT",
        "CONVERT_FROM",
        "CONVERT_TO",
        "COUNT",
        "CUME_DIST",
        "CURRENT_DATE",
        "CURRENT_TIME",
        "CURRENT_TIMESTAMP",
        "DATE_PART",
        "DATE_TRUNC",
        "DECODE",
        "DEGREES",
        "DENSE_RANK",
        "DIAMETER",
        "DIV",
        "ENCODE",
        "ENUM_FIRST",
        "ENUM_LAST",
        "ENUM_RANGE",
        "EVERY",
        "EXP",
        "EXTRACT",
        "FAMILY",
        "FIRST_VALUE",
        "FLOOR",
        "FORMAT",
        "GET_BIT",
        "GET_BYTE",
        "HEIGHT",
        "HOST",
        "HOSTMASK",
        "INET_MERGE",
        "INET_SAME_FAMILY",
        "INITCAP",
        "ISCLOSED",
        "ISFINITE",
        "ISOPEN",
        "JUSTIFY_DAYS",
        "JUSTIFY_HOURS",
        "JUSTIFY_INTERVAL",
        "LAG",
        "LAST_VALUE",
        "LEAD",
        "LEFT",
        "LENGTH",
        "LINE",
        "LN",
        "LOCALTIME",
        "LOCALTIMESTAMP",
        "LOG",
        "LOG10",
        "LOWER",
        "LPAD",
        "LSEG",
        "LTRIM",
        "MAKE_DATE",
        "MAKE_INTERVAL",
        "MAKE_TIME",
        "MAKE_TIMESTAMP",
        "MAKE_TIMESTAMPTZ",
        "MASKLEN",
        "MAX",
        "MD5",
        "MIN",
        "MOD",
        "NETMASK",
        "NETWORK",
        "NOW",
        "NPOINTS",
        "NTH_VALUE",
        "NTILE",
        "NUM_NONNULLS",
        "NUM_NULLS",
        "OCTET_LENGTH",
        "OVERLAY",
        "PARSE_IDENT",
        "PATH",
        "PCLOSE",
        "PERCENT_RANK",
        "PG_CLIENT_ENCODING",
        "PI",
        "POINT",
        "POLYGON",
        "POPEN",
        "POSITION",
        "POWER",
        "QUOTE_IDENT",
        "QUOTE_LITERAL",
        "QUOTE_NULLABLE",
        "RADIANS",
        "RADIUS",
        "RANDOM",
        "RANK",
        "REGEXP_MATCH",
        "REGEXP_MATCHES",
        "REGEXP_REPLACE",
        "REGEXP_SPLIT_TO_ARRAY",
        "REGEXP_SPLIT_TO_TABLE",
        "REPEAT",
        "REPLACE",
        "REVERSE",
        "RIGHT",
        "ROUND",
        "ROW_NUMBER",
        "RPAD",
        "RTRIM",
        "SCALE",
        "SET_BIT",
        "SET_BYTE",
        "SET_MASKLEN",
        "SHA224",
        "SHA256",
        "SHA384",
        "SHA512",
        "SIGN",
        "SPLIT_PART",
        "SQRT",
        "STARTS_WITH",
        "STATEMENT_TIMESTAMP",
        "STRING_TO_ARRAY",
        "STRPOS",
        "SUBSTR",
        "SUBSTRING",
        "SUM",
        "TEXT",
        "TIMEOFDAY",
        "TO_ASCII",
        "TO_CHAR",
        "TO_DATE",
        "TO_HEX",
        "TO_NUMBER",
        "TO_TIMESTAMP",
        "TRANSACTION_TIMESTAMP",
        "TRANSLATE",
        "TRIM",
        "TRUNC",
        "UNNEST",
        "UPPER",
        "VERSION",
        "WIDTH",
        "WIDTH_BUCKET",
        "XMLAGG"
    ],
    "datatypes": [
        "ANY",
        "ANYARRAY",
        "ANYELEMENT",
        "ANYENUM",
        "ANYNONARRAY",
        "ANYRANGE",
        "BIGINT",
        "BIGSERIAL",
        "BIT",
        "BIT VARYING",
        "BOOL",
        "BOOLEAN",
        "BOX",
        "BYTEA",
        "CHAR",
        "CHARACTER",
        "CHARACTER VARYING",
        "CIDR",
        "CIRCLE",
        "CSTRING",
        "DATE",
        "DECIMAL",
        "DOUBLE PRECISION",
        "EVENT_TRIGGER",
        "FDW_HANDLER",
        "FLOAT4",
        "FLOAT8",
        "INET",
        "INT",
        "INT2",
        "INT4",
        "INT8",
        "INTEGER",
        "INTERNAL",
        "INTERVAL",
        "JSON",
        "JSONB",
        "LANGUAGE_HANDLER",
        "LINE",
        "LSEG",
        "MACADDR",
        "MACADDR8",
        "MONEY",
        "NUMERIC",
        "OID",
        "OPAQUE",
        "PATH",
        "PG_LSN",
        "POINT",
        "POLYGON",
        "REAL",
        "RECORD",
        "REGCLASS",
        "REGCONFIG",
        "REGDICTIONARY",
        "REGNAMESPACE",
        "REGOPER",
        "REGOPERATOR",
        "REGPROC",
        "REGPROCEDURE",
        "REGROLE",
        "REGTYPE",
        "SERIAL",
        "SERIAL2",
        "SERIAL4",
        "SERIAL8",
        "SMALLINT",
        "SMALLSERIAL",
        "TEXT",
        "TIME",
        "TIMESTAMP",
        "TRIGGER",
        "TSQUERY",
        "TSVECTOR",
        "TXID_SNAPSHOT",
        "UUID",
        "VARBIT",
        "VARCHAR",
        "VOID",
        "XML"
    ],
    "reserved": [
        "ALL",
        "ANALYSE",
        "ANALYZE",
        "AND",
        "ANY",
        "ARRAY",
        "AS",
        "ASC",
        "ASYMMETRIC",
        "BOTH",
        "CASE",
        "CAST",
        "CHECK",
        "COLLATE",
        "COLUMN",
        "CONSTRAINT",
        "CREATE",
        "CURRENT_CATALOG",
        "CURRENT_DATE",
        "CURRENT_ROLE",
        "CURRENT_TIME",
        "CURRENT_TIMESTAMP",
        "CURRENT_USER",
        "DEFAULT",
        "DEFERRABLE",
        "DESC",
        "DISTINCT",
        "DO",
        "ELSE",
        "END",
        "EXCEPT",
        "FALSE",
        "FETCH",
        "FOR",
        "FOREIGN",
        "FROM",
        "GRANT",
        "GROUP",
        "HAVING",
        "IN",
        "INITIALLY",
        "INTERSECT",
        "INTO",
        "LATERAL",
        "LEADING",
        "LIMIT",
        "LOCALTIME",
        "LOCALTIMESTAMP",
        "NOT",
        "NULL",
        "OFFSET",
        "ON",
        "ONLY",
        "OR",
        "ORDER",
        "PLACING",
        "PRIMARY",
        "REFERENCES",
        "RETURNING",
        "SELECT",
        "SESSION_USER",
        "SOME",
        "SYMMETRIC",
        "TABLE",
        "THEN",
        "TO",
        "TRAILING",
        "TRUE",
        "UNION",
        "UNIQUE",
        "USER",
        "USING",
        "VARIADIC",
        "WHEN",
        "WHERE",
        "WINDOW",
        "WITH",
        "AUTHORIZATION",
        "BINARY",
        "COLLATION",
        "CONCURRENTLY",
        "CROSS",
        "CURRENT_SCHEMA",
        "FREEZE",
        "FULL",
        "ILIKE",
        "INNER",
        "IS",
        "ISNULL",
        "JOIN",
        "LEFT",
        "LIKE",
        "NATURAL",
        "NOTNULL",
        "OUTER",
        "OVERLAPS",
        "RIGHT",
        "SIMILAR",
        "TABLESAMPLE",
        "VERBOSE"
    ]
}