Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
export const skill = {
name: "query",
description:
"Use when running SQL queries, executing SELECT/INSERT/UPDATE/DELETE statements, or fetching data from databases",
content: `# Execute SQL
## Overview
Run SQL queries against databases managed by Bytebase.
## Prerequisites
- Know the instance and database name
- Have \`bb.sql.query\` permission
## Workflow
1. **Get the schema**:
\`\`\`
search_api(operationId="SQLService/Query")
\`\`\`
2. **Find databases** (if needed):
\`\`\`
call_api(operationId="DatabaseService/SearchDatabases", body={
"filter": "name.contains(\\"db_name\\")"
})
\`\`\`
SearchDatabases searches across projects where the member can get databases. In a project context, add \`project == "projects/{project-id}"\` to the filter to limit results to that project.
Filter examples:
- \`name.contains("employee")\` - database name contains "employee"
- \`project == "projects/{project-id}"\` - databases in a project
- \`instance == "instances/{instance-id}"\` - databases in a workspace instance
- \`instance == "projects/{project-id}/instances/{instance-id}"\` - databases in a project instance
- \`engine == "MYSQL"\` - MySQL databases only
- \`environment == "environments/prod" && name.contains("user")\` - combine filters
**Optionally inspect \`instanceResource.dataSources\`** if you need to target a specific data source. Prefer \`type: "READ_ONLY"\` over \`type: "ADMIN"\` when choosing explicitly.
3. **Execute SQL**:
\`\`\`
call_api(operationId="SQLService/Query", body={
"name": "projects/{project-id}/instances/{instance-id}/databases/{database-name}",
"statement": "SELECT * FROM users LIMIT 10"
})
\`\`\`
Include \`dataSourceId\` only when you need to override the server-selected data source.
## Notes
- Query results may contain masked values due to data masking policies. Do not remove or modify masked values.
- Full mask: \`******\`
- Partial mask: \`**rn**\` (only "rn" visible)
- **Displaying partial masks:** Use backticks or code blocks when presenting results. Without escaping, markdown interprets \`**text**\` as bold formatting.
- Preserve the exact canonical database name returned by SearchDatabases. Workspace databases use \`instances/{instance}/databases/{database}\`; project-instance databases use \`projects/{project}/instances/{instance}/databases/{database}\`.
## Common Errors
| Error | Cause | Fix |
|-------|-------|-----|
| database not found | Wrong instance/database name | List databases first |
| permission denied | Missing bb.sql.query | Check user permissions |
| syntax error | Invalid SQL | Check SQL syntax for the database engine |`,
} as const;