Anyline

What it does

When your agent uses it

• Tasks that involve SQL

Example prompts

• “/anyline”

Requirements

• A credential in DEFAULT_PRIMARY_KEY
• A credential in IS_UPPER_KEY

Workflow steps

4 steps, taken from the step headings in SKILL.md.

1. 1通过 ServiceProxy 切换
2. 2通过表名前缀临时切换
3. 3临时数据源
4. 4虚拟数据源（仅生成SQL不执行）

What it can do on your machine

Read from SKILL.md and the folder at commit e20f9f2. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  No scripts in the folder and no shell commands in SKILL.md (its code samples are java).

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  No URLs in SKILL.md.

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names these keys or tokens, usually read from environment variables:

  • DEFAULT_PRIMARY_KEY
  • IS_UPPER_KEY
  • IS_LOWER_KEY

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Anyline loads about 1.3k tokens when it runs, and up to ~65k if it reads all its reference files. Until then it costs about 36 tokens; SKILL.md has 154 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~36

When it runs · the whole SKILL.md, loaded when a task matches

~1.3k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~65k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from anylineorg/anyline at commit e20f9f2, republished under its Apache-2.0 licence (© anylineorg). 154 words, ~1,316 tokens.

name

anyline

description

AnyLine数据库操作开发规范，涵盖动态数据源注册切换注销、DDL动态建表改表、DML增删改与事务管理、DQL动态查询与聚合统计、元数据管理、查询结果集的聚合、过滤、格式转换等数学计算，AnyLine方法内部会自动适配100+数据库方言，调用方法时忽略不同数据库差异。

// 获取指定数据源的 Service
AnylineService crmService = ServiceProxy.service("crm");
crmService.select("CRM_USER");

// 获取默认数据源的 Service
AnylineService defService = ServiceProxy.service();
defService.select("HR_USER");

// 在表名前添加数据源名称，仅当前查询有效
service.select("<crm>CRM_USER");

// 创建临时数据源，用完自动回收
DataSource ds = DataSourceUtil.build(...);
AnylineService service = ServiceProxy.temporary(ds);
service.select("CRM_USER");

// 根据数据库类型创建虚拟数据源，用于生成SQL脚本
AnylineService service = ServiceProxy.service(DatabaseType.POSTGRESQL);
ConfigStore configs = new DefaultConfigStore();
service.selects("CRM_USER", configs);
List<Run> runs = configs.runs();
// 获取生成的 PostgreSQL SQL

List<Run> runs = configs.runs();
for (Run run:runs){
    System.out.println("无占位符 sql:"+run.getFinalQuery(false));
    System.out.println("有占位符 sql:"+run.getFinalQuery());
    System.out.println("占位values:"+run.getValues());
}

ConfigStore configs = new DefaultConfigStore().execute(false);//false表示最后实际操作数据库的一步不执行
DataSet set = service.selects(table, configs);
System.out.println(set);//因为最后一步没有执行，所以这里应该输出空集合
 
List<Run> runs = configs.runs();
for (Run run:runs){
     System.out.println("无占位符 sql:"+run.getFinalQuery(false));
     System.out.println("有占位符 sql:"+run.getFinalQuery());
     System.out.println("占位values:"+run.getValues());
}

Table table = service.metadata().table("sso_user"); //获取表结构
table.execute(false);//不执行SQL
service.ddl().create(table);
List<Run> runs = table.runs(); //返回创建表的DDL
for (Run run : runs){
    String sql = run.getFinalUpdate();
    System.out.println(sql);
}

// 主键默认列名
ConfigTable.DEFAULT_PRIMARY_KEY = "ID";

// 是否自动检测元数据
ConfigTable.IS_AUTO_CHECK_METADATA = true;

// 元数据缓存时间（秒）
ConfigTable.METADATA_CACHE_SECOND = 3600 * 24;

// 是否返回空实例替代null
ConfigTable.IS_RETURN_EMPTY_INSTANCE_REPLACE_NULL = true;

// 列名大小写处理
ConfigTable.IS_UPPER_KEY = true;  // 列名转大写
ConfigTable.IS_LOWER_KEY = false; // 列名转小写

// 空值处理
ConfigTable.IS_INSERT_NULL_COLUMN = false;
ConfigTable.IS_UPDATE_NULL_COLUMN = false;
ConfigTable.IS_INSERT_EMPTY_COLUMN = false;
ConfigTable.IS_UPDATE_EMPTY_COLUMN = false;

© anylineorg, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 13 other files (references) in .ai/skills/anyline of anylineorg/anyline.

• SKILL.md
• references/authorize.md
• references/condition.md
• references/datarow.md
• references/dataset.md
• references/datasource.md
• references/ddl.md
• references/dml.md
• references/dql.md
• references/graph.md
• references/interceptor.md
• references/listener.md
• references/metadata.md
• references/transaction.md

Open the folder on GitHubat commit e20f9f2