Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.
PawSQL can review SQL before a change is merged or released and return a pass, warning, or block decision to the engineering platform. Start by distinguishing a prebuilt connector from a custom API integration.
Jenkins, GitHub Actions, GitLab CI, Azure Pipelines, and others
OpenAPI or custom adapter
No prebuilt connector
Internal engineering platforms
Developer portals, approval systems, and release platforms
OpenAPI, webhook, or custom adapter
No prebuilt connector
“No prebuilt connector” does not mean the platform cannot integrate with PawSQL. It means your pipeline or integration service must orchestrate the OpenAPI workflow.
Prepare the PawSQL endpoint, an integration identity, the target project, a review workspace, and an approved policy. The workspace must match the database engine and version used by the SQL. Add DDL or a database connection when schema context is required.
Automated review does not execute SQL or replace business validation, database authorization, change approval, backup, and rollback controls. Complete acceptance testing with sanitized SQL and a non-production environment first.
{"docsConfig":{"theme":"palm","$schema":"https://mintlify.com/docs.json","name":"PawSQL","description":"PawSQL 让数据库性能优化自动化且可验证：SQL 审核、语义级查询重写、基于代价的索引推荐。文档内容面向工程师与 coding agents，检索友好。","colors":{"primary":"#0D9373","light":"#26BD6C","dark":"#0D9373"},"favicon":"https://mintcdn.com/pawsql/cdtFYB4QMM1nGHhK/images/favicon.png?fit=max\u0026auto=format\u0026n=cdtFYB4QMM1nGHhK\u0026q=85\u0026s=4e659dcefa0164171c7042a2a69a1e3b","navbar":{"links":[],"primary":{"type":"button","label":"PawSQL Cloud","href":"https://www.pawsql.com"}},"seo":{"organization":{"id":"https://www.pawsql.com/#organization","name":"PawSQL","legalName":"北京图灵睿数科技有限公司","url":"https://www.pawsql.com","logo":"https://www.pawsql.com/logo.png","sameAs":["https://github.com/PawSQL","https://x.com/pawsql_service"]},"indexing":"navigable"},"icons":{"library":"lucide"},"styling":{"eyebrows":"breadcrumbs","latex":false},"interaction":{"drilldown":true},"markdown":{"instructions":["PawSQL 是一个产品：Cloud 是公网部署形态，Engine / Optimizer / Auditor / Advisor / Patroller 是同一产品的组件与交付形态，不是彼此独立的产品。 / PawSQL is a single product: Cloud is the public deployment form, while Engine / Optimizer / Auditor / Advisor / Patroller are components and delivery forms of the same product, not separate products.","术语以站内术语表为准：SQL 审核对应英文 SQL Review，查询重写对应 Query Rewrite，索引推荐对应 Index Recommendation；英文内容统一用 Review，不用 Audit。 / Use the site glossary for terminology: 审核 is SQL Review, 重写 is Query Rewrite, 索引推荐 is Index Recommendation; English content uses Review, never Audit.","引用能力范围或版本支持时以对应页面为准；标注 unknown、或 status 非 published 的内容表示尚未经产品核实，不应作为事实引用。 / Cite capability scope and version support from the corresponding page; content marked unknown, or with a status other than published, is not yet product-verified and must not be cited as fact."]},"navigation":{"languages":[{"language":"zh","footer":{"socials":{"github":"https://github.com/PawSQL","website":"https://www.pawsql.com"},"links":[{"header":"产品","items":[{"label":"PawSQL Cloud","href":"https://www.pawsql.com"},{"label":"核心能力","href":"/features"},{"label":"使用场景","href":"/use-cases"}]},{"header":"文档","items":[{"label":"快速开始","href":"/getting-started"},{"label":"用户手册","href":"/user-guide"}]},{"header":"开源与社区","items":[{"label":"GitHub","href":"https://github.com/PawSQL"},{"label":"PawSQL MCP","href":"https://github.com/PawSQL/pawsql-mcp"}]}]},"href":"getting-started"},{"language":"en","footer":{"socials":{"github":"https://github.com/PawSQL","website":"https://www.pawsql.com"},"links":[{"header":"Product","items":[{"label":"PawSQL Cloud","href":"https://www.pawsql.com"},{"label":"Features","href":"/en/features"},{"label":"Use Cases","href":"/en/use-cases"}]},{"header":"Documentation","items":[{"label":"Quickstart","href":"/en/getting-started"},{"label":"User Guide","href":"/en/user-guide"}]},{"header":"Open Source \u0026 Community","items":[{"label":"GitHub","href":"https://github.com/PawSQL"},{"label":"PawSQL MCP","href":"https://github.com/PawSQL/pawsql-mcp"}]}]},"href":"en/getting-started"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"pawsql","hasAudioNarration":false,"actualSubdomain":"pawsql","customDomains":["docs.pawsql.com"],"gitSource":{"type":"github","owner":"pawsql","repo":"pawsql-docs-mantlify","deployBranch":"publish","contentDirectory":"docs","isPrivate":false,"mountPath":"","label":""},"chroma":{"latestBuiltDeploymentHistoryId":"6accb09d9ac0e9762613b8c5","collectionId":"eb10d5ad-de18-4ce3-a39b-e4cfa6b69e54","liveDeploymentHistoryId":"6accb09d9ac0e9762613b8c5","schemaVersion":"v3"},"feedback":{"thumbs":true,"issues":true,"edits":true},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6accb09d9ac0e9762613b8c5","clientVersion":"0.0.3990","searchFilterCounts":[{"language":"zh","tag":"开始使用","count":51},{"language":"en","tag":"Getting Started","count":51},{"language":"zh","tag":"用户手册","count":48},{"language":"en","tag":"User Guide","count":48},{"language":"zh","tag":"API 参考文档","count":15},{"language":"en","tag":"API","count":15},{"language":"en","tag":"SQL Optimization","count":13},{"language":"zh","tag":"使用场景与核心能力","count":12},{"language":"zh","tag":"CI/CD 与平台集成","count":12},{"language":"en","tag":"Use Cases \u0026 Features","count":12},{"language":"en","tag":"CI/CD \u0026 Platform Integration","count":12},{"language":"zh","tag":"巡检与慢查询治理","count":9},{"language":"zh","tag":"优化服务接口","count":9},{"language":"en","tag":"Batch Optimization \u0026 Patrol","count":9},{"language":"zh","tag":"SQL 审核","count":8},{"language":"en","tag":"SQL Review","count":8},{"language":"zh","tag":"核心能力","count":7},{"language":"en","tag":"Features","count":7},{"language":"zh","tag":"CI/CD 集成接口","count":6},{"language":"en","tag":"CD/CD Integration","count":6}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-v7-file-tree","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"per-site-search-delta","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-private-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-nav-generations","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"isAtlas":false,"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"en/user-guide/cicd","slug":"/en/user-guide/cicd","pageMetadata":{"id":"en-user-guide-cicd-index","title":"CI/CD and Platform Integrations Overview","description":"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.","type":"guide","subtype":"integration","layout":"index","product":"pawsql","status":"published","language":"en","translationKey":"user-guide-cicd-index","href":"/en/user-guide/cicd/index"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Card,CardGroup,Heading,Info,Mermaid,Table,Warning}=_components;if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Info)_missingMdxReference(`Info`,true);if(!Mermaid)_missingMdxReference(`Mermaid`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`PawSQL can review SQL before a change is merged or released and return a pass, warning, or block decision to the engineering platform. Start by distinguishing a `,_jsx(_components.strong,{children:`prebuilt connector`}),` from a `,_jsx(_components.strong,{children:`custom API integration`}),`.`]}),`\n`,_jsx(Heading,{level:`2`,id:`support-matrix`,children:`Support matrix`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Integration type`}),_jsx(_components.th,{children:`Platform`}),_jsx(_components.th,{children:`Delivery model`}),_jsx(_components.th,{children:`Availability`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Source repository`}),_jsx(_components.td,{children:`Tencent CODING`}),_jsx(_components.td,{children:`Prebuilt PawSQL connector`}),_jsx(_components.td,{children:`Ready to configure`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Source repository`}),_jsx(_components.td,{children:`GitHub`}),_jsx(_components.td,{children:`Prebuilt PawSQL connector`}),_jsx(_components.td,{children:`Ready to configure`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Source repository`}),_jsx(_components.td,{children:`GitLab`}),_jsx(_components.td,{children:`Prebuilt PawSQL connector`}),_jsx(_components.td,{children:`Ready to configure`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`CI/CD pipeline`}),_jsx(_components.td,{children:`BlueKing`}),_jsx(_components.td,{children:`Prebuilt PawSQL connector`}),_jsx(_components.td,{children:`Ready to configure`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Other repositories or pipelines`}),_jsx(_components.td,{children:`Jenkins, GitHub Actions, GitLab CI, Azure Pipelines, and others`}),_jsx(_components.td,{children:`OpenAPI or custom adapter`}),_jsx(_components.td,{children:`No prebuilt connector`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Internal engineering platforms`}),_jsx(_components.td,{children:`Developer portals, approval systems, and release platforms`}),_jsx(_components.td,{children:`OpenAPI, webhook, or custom adapter`}),_jsx(_components.td,{children:`No prebuilt connector`})]})]})]}),`\n`,_jsx(Info,{children:_jsx(_components.p,{children:`“No prebuilt connector” does not mean the platform cannot integrate with PawSQL. It means your pipeline or integration service must orchestrate the OpenAPI workflow.`})}),`\n`,_jsx(Heading,{level:`2`,id:`choose-a-path`,children:`Choose a path`}),`\n`,_jsxs(CardGroup,{cols:2,children:[_jsx(Card,{title:`Repository connectors`,href:`/en/user-guide/cicd/repositories`,icon:`code-branch`,children:_jsx(_components.p,{children:`Connect CODING, GitHub, or GitLab and review SQL on repository events.`})}),_jsx(Card,{title:`BlueKing pipeline connector`,href:`/en/user-guide/cicd/blueking`,icon:`diagram-project`,children:_jsx(_components.p,{children:`Add PawSQL review and a quality gate to a BlueKing pipeline.`})}),_jsx(Card,{title:`OpenAPI pipeline integration`,href:`/en/user-guide/cicd/openapi-pipeline`,icon:`code`,children:_jsx(_components.p,{children:`Build a review stage for a CI/CD system without a prebuilt connector.`})}),_jsx(Card,{title:`Custom platform integration`,href:`/en/user-guide/cicd/unsupported-platforms`,icon:`puzzle-piece`,children:_jsx(_components.p,{children:`Choose OpenAPI, webhooks, or an integration service for Jenkins, Gitee, CodeArts, and internal platforms.`})})]}),`\n`,_jsx(Heading,{level:`2`,id:`standard-flow`,children:`Standard flow`}),`\n`,_jsx(Mermaid,{chart:`flowchart TD\n A[\"Commit, review, or pipeline\"] --> B[\"Identify SQL changes\"]\n B --> C[\"Create PawSQL review\"]\n C --> D[\"Run rules and analysis\"]\n D --> E{\"Quality gate\"}\n E -->|Pass| F[\"Continue merge or release\"]\n E -->|Block| G[\"Return actionable findings\"]`}),`\n`,_jsx(Heading,{level:`2`,id:`before-you-begin`,children:`Before you begin`}),`\n`,_jsx(_components.p,{children:`Prepare the PawSQL endpoint, an integration identity, the target project, a review workspace, and an approved policy. The workspace must match the database engine and version used by the SQL. Add DDL or a database connection when schema context is required.`}),`\n`,_jsx(Warning,{children:_jsx(_components.p,{children:`Automated review does not execute SQL or replace business validation, database authorization, change approval, backup, and rollback controls. Complete acceptance testing with sanitized SQL and a non-production environment first.`})}),`\n`,_jsx(Heading,{level:`2`,id:`next-step`,children:`Next step`}),`\n`,_jsxs(_components.p,{children:[`Read the `,_jsx(_components.a,{href:`/en/user-guide/cicd/concepts`,children:`integration model and core concepts`}),` and `,_jsx(_components.a,{href:`/en/user-guide/cicd/prerequisites`,children:`prerequisites and security`}),`, then choose a connector.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"id":"en-user-guide-cicd-index","title":"CI/CD and Platform Integrations Overview","description":"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.","type":"guide","subtype":"integration","layout":"index","product":"pawsql","status":"published","language":"en","translationKey":"user-guide-cicd-index","href":"/en/user-guide/cicd/index"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Support matrix","slug":"support-matrix","depth":2,"children":[]},{"title":"Choose a path","slug":"choose-a-path","depth":2,"children":[]},{"title":"Standard flow","slug":"standard-flow","depth":2,"children":[]},{"title":"Before you begin","slug":"before-you-begin","depth":2,"children":[]},{"title":"Next step","slug":"next-step","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"pawsql","siteName":"PawSQL","title":"CI/CD and Platform Integrations Overview - PawSQL","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"zh":{"href":"/user-guide/cicd/index","matchLevel":1},"en":{"href":"/en/user-guide/index","matchLevel":2}}},"lastModified":"2026-09-18T00:19:59.264Z","originalFileLocation":"en/user-guide/cicd/index.mdx","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.\">\u003cmeta data-mint-head name=\"application-name\" content=\"PawSQL\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"CI/CD and Platform Integrations Overview - PawSQL\">\u003cmeta data-mint-head property=\"og:description\" content=\"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"PawSQL\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.pawsql.com/en/user-guide/cicd\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://pawsql.mintlify.app/_mintlify/api/og/v2?division=Documentation\u0026amp;title=CI%2FCD+and+Platform+Integrations+Overview\u0026amp;description=Use+prebuilt+connectors+or+PawSQL+OpenAPI+to+review+SQL+in+commits%2C+code+reviews%2C+and+delivery+pipelines.\u0026amp;theme=6d404b338307bd95eaa82301\u0026amp;signature=d28852a5a62864c76663f35d6a2dda3fafbfb34146a3cddfa7e841318f059030\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"CI/CD and Platform Integrations Overview - PawSQL\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://pawsql.mintlify.app/_mintlify/api/og/v2?division=Documentation\u0026amp;title=CI%2FCD+and+Platform+Integrations+Overview\u0026amp;description=Use+prebuilt+connectors+or+PawSQL+OpenAPI+to+review+SQL+in+commits%2C+code+reviews%2C+and+delivery+pipelines.\u0026amp;theme=6d404b338307bd95eaa82301\u0026amp;signature=d28852a5a62864c76663f35d6a2dda3fafbfb34146a3cddfa7e841318f059030\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/pawsql/9yivK1GUkHFKPs6i/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"PawSQL\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#0D9373\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.pawsql.com/en/user-guide/cicd\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/user-guide/cicd.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://docs.pawsql.com/en/user-guide/cicd\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"zh\" href=\"https://docs.pawsql.com/user-guide/cicd\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://docs.pawsql.com/user-guide/cicd\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://www.pawsql.com/#organization\",\"name\":\"PawSQL\",\"legalName\":\"北京图灵睿数科技有限公司\",\"url\":\"https://www.pawsql.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://www.pawsql.com/logo.png\"},\"sameAs\":[\"https://github.com/PawSQL\",\"https://x.com/pawsql_service\"]},{\"@type\":\"WebSite\",\"@id\":\"https://docs.pawsql.com#website\",\"name\":\"PawSQL\",\"url\":\"https://docs.pawsql.com\",\"publisher\":{\"@id\":\"https://www.pawsql.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.pawsql.com/en/user-guide/cicd#webpage\",\"url\":\"https://docs.pawsql.com/en/user-guide/cicd\",\"name\":\"CI/CD and Platform Integrations Overview\",\"description\":\"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.\",\"dateModified\":\"2026-09-18T00:19:59.264Z\",\"isPartOf\":{\"@id\":\"https://docs.pawsql.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.pawsql.com/en/user-guide/cicd#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.pawsql.com/en/user-guide/cicd#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"User Guide\",\"item\":\"https://docs.pawsql.com/en/user-guide/index\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CI/CD \u0026 Platform Integration\",\"item\":\"https://docs.pawsql.com/en/user-guide/cicd/index\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CI/CD and Platform Integrations Overview\",\"item\":\"https://docs.pawsql.com/en/user-guide/cicd\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.pawsql.com/en/user-guide/cicd#article\",\"headline\":\"CI/CD and Platform Integrations Overview\",\"name\":\"CI/CD and Platform Integrations Overview\",\"description\":\"Use prebuilt connectors or PawSQL OpenAPI to review SQL in commits, code reviews, and delivery pipelines.\",\"url\":\"https://docs.pawsql.com/en/user-guide/cicd\",\"mainEntityOfPage\":{\"@id\":\"https://docs.pawsql.com/en/user-guide/cicd#webpage\"},\"dateModified\":\"2026-09-18T00:19:59.264Z\",\"publisher\":{\"@id\":\"https://www.pawsql.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.pawsql.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"PawSQL\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"PawSQL","nav":{"global":null,"languages":[{"language":"zh","footer":{"socials":{"github":"https://github.com/PawSQL","website":"https://www.pawsql.com"},"links":[{"header":"产品","items":[{"label":"PawSQL Cloud","href":"https://www.pawsql.com"},{"label":"核心能力","href":"/features"},{"label":"使用场景","href":"/use-cases"}]},{"header":"文档","items":[{"label":"快速开始","href":"/getting-started"},{"label":"用户手册","href":"/user-guide"}]},{"header":"开源与社区","items":[{"label":"GitHub","href":"https://github.com/PawSQL"},{"label":"PawSQL MCP","href":"https://github.com/PawSQL/pawsql-mcp"}]}]},"pages":[{"title":"zh","href":"/user-guide/cicd"}]},{"language":"en","footer":{"socials":{"github":"https://github.com/PawSQL","website":"https://www.pawsql.com"},"links":[{"header":"Product","items":[{"label":"PawSQL Cloud","href":"https://www.pawsql.com"},{"label":"Features","href":"/en/features"},{"label":"Use Cases","href":"/en/use-cases"}]},{"header":"Documentation","items":[{"label":"Quickstart","href":"/en/getting-started"},{"label":"User Guide","href":"/en/user-guide"}]},{"header":"Open Source \u0026 Community","items":[{"label":"GitHub","href":"https://github.com/PawSQL"},{"label":"PawSQL MCP","href":"https://github.com/PawSQL/pawsql-mcp"}]}]},"tabs":[{"tab":"Getting Started","icon":"folder-open","groups":[{"group":"Quickstart","icon":"rocket","root":{"title":"What is PawSQL?","icon":"wifi","href":"/en/getting-started"},"expanded":true,"directory":"accordion","pages":[{"title":"Optimize Your First SQL Query","icon":"bolt","href":"/en/getting-started/quickstart"},{"title":"Choose How to Use PawSQL","icon":"route","href":"/en/getting-started/choose-access"},{"title":"Supported Databases","icon":"database","href":"/en/getting-started/supported-databases"}]},{"group":"User Guide","icon":"book-open","root":{"title":"User Guide Overview","icon":"book-open","href":"/en/user-guide/index"},"expanded":true,"pages":[{"group":"Installation \u0026 Access","icon":"download","root":{"title":"Installation and Access Overview","href":"/en/user-guide/installation/index"},"expanded":true,"pages":[{"title":"Use PawSQL Cloud","href":"/en/user-guide/installation/pawsql-cloud"},{"title":"Deploy PawSQL Server","href":"/en/user-guide/installation/pawsql-server"},{"title":"Install IDE Extensions","href":"/en/user-guide/installation/ide-plugins"},{"title":"Authentication","href":"/en/user-guide/installation/authentication"},{"title":"Verify Installation and Connectivity","href":"/en/user-guide/installation/verify-installation"}]},{"group":"Workspaces \u0026 Context","icon":"box","root":{"title":"Workspaces and Database Context","href":"/en/user-guide/workspaces/index"},"pages":[{"title":"Create a Workspace from DDL","href":"/en/user-guide/workspaces/create-from-ddl"},{"title":"Create a Workspace from a Database","href":"/en/user-guide/workspaces/create-from-database"}]},{"group":"SQL Optimization","icon":"wand-sparkles","root":{"title":"SQL Optimization Overview","href":"/en/user-guide/optimization/index"},"pages":[{"title":"Input SQL to Optimize","href":"/en/user-guide/optimization/create-workload"},{"title":"Create and Configure an Optimization Task","href":"/en/user-guide/optimization/setup-optimization"},{"title":"Read Optimization Results","href":"/en/user-guide/optimization/explain-output"},{"title":"Evaluate and Apply Suggestions","href":"/en/user-guide/optimization/apply-suggestions"}]},{"group":"SQL Review","icon":"shield-check","root":{"title":"SQL Review Overview","href":"/en/user-guide/sql-audit/index"},"pages":[{"title":"Create a Review Ticket","href":"/en/user-guide/sql-audit/create-review-task"},{"title":"Read Review Results","href":"/en/user-guide/sql-audit/read-audit-results"},{"title":"Resolve Findings","href":"/en/user-guide/sql-audit/resolve-findings"},{"title":"Manual Review and Approval","href":"/en/user-guide/sql-audit/manual-review-and-approval"},{"title":"History, Reports, and Export","href":"/en/user-guide/sql-audit/history-reports-and-export"},{"title":"Select a Review Policy","href":"/en/user-guide/sql-audit/select-audit-policy"},{"title":"Workspace and Review Context","href":"/en/user-guide/sql-audit/configure-review-context"},{"title":"Control High-Risk SQL","href":"/en/user-guide/sql-audit/high-risk-sql-control"}]},{"group":"Batch Optimization \u0026 Patrol","icon":"activity","root":{"title":"Performance Governance Workflow","href":"/en/user-guide/performance/index"},"pages":[{"title":"Connect Database Instances","href":"/en/user-guide/performance/connect-instance"},{"group":"Slow Query Governance","pages":[{"title":"Collect Slow Queries","href":"/en/user-guide/performance/collect-slow-sql"},{"title":"SQL Aggregation and Deduplication","href":"/en/user-guide/performance/aggregate-dedup"},{"title":"Batch Analysis and Optimization","href":"/en/user-guide/performance/batch-optimize"},{"title":"Create an Optimization Ticket","href":"/en/user-guide/performance/create-optimize-ticket"},{"title":"Track Governance Progress","href":"/en/user-guide/performance/track-progress"}]},{"group":"Database Object Patrol","pages":[{"title":"Object Patrol Task","href":"/en/user-guide/performance/patrol-task"},{"title":"Patrol Task Report","href":"/en/user-guide/performance/reports"},{"title":"Create a Patrol Issue Ticket","href":"/en/user-guide/performance/create-patrol-ticket"}]}]},{"group":"Rules \u0026 Quality Policy","icon":"sliders-horizontal","root":{"title":"Review Policy Overview","href":"/en/user-guide/rules-policy/index"},"pages":[{"title":"Manage Review Policies","href":"/en/user-guide/rules-policy/rule-sets"},{"title":"Manage Rules","href":"/en/user-guide/rules-policy/configure-rules"},{"title":"Configure the SQL Quality Gate","href":"/en/user-guide/rules-policy/quality-gate"}]},{"group":"Developer Tool Integration","icon":"code","root":{"title":"Developer Tool Integration Overview","href":"/en/user-guide/dev-tools/index"},"pages":[{"title":"Review SQL Before Execution in DBeaver","href":"/en/user-guide/dev-tools/dbeaver"},{"title":"Optimize SQL in JetBrains IDEs","href":"/en/user-guide/dev-tools/jetbrains"},{"title":"Review and Optimize SQL in DataGrip","href":"/en/user-guide/dev-tools/datagrip"},{"title":"Optimize SQL in Visual Studio Code","href":"/en/user-guide/dev-tools/vscode"},{"title":"Optimize SQL with PawSQL MCP","description":"Connect PawSQL to an MCP-compatible coding assistant, supply reliable database context, and safely evaluate rewrites, index recommendations, and performance evidence.","href":"/en/user-guide/dev-tools/mcp"}]},{"group":"CI/CD \u0026 Platform Integration","icon":"git-merge","root":{"title":"CI/CD and Platform Integrations Overview","href":"/en/user-guide/cicd/index"},"pages":[{"title":"Integration Model and Core Concepts","description":"Learn how events, SQL change sets, workspaces, review policies, and quality gates fit together.","href":"/en/user-guide/cicd/concepts"},{"title":"Prerequisites and Security","description":"Prepare PawSQL, review context, platform permissions, network paths, credentials, and data controls before connecting a repository or pipeline.","href":"/en/user-guide/cicd/prerequisites"},{"title":"SQL Quality Gates and Feedback","description":"Convert PawSQL review evidence into pass, warning, or block decisions and publish the result to the source platform.","href":"/en/user-guide/cicd/pipeline-gate"},{"title":"Repository Connectors","description":"Use prebuilt PawSQL connectors for Tencent CODING, GitHub, and GitLab to review SQL on commits and code reviews.","href":"/en/user-guide/cicd/repositories"},{"title":"Integrate Tencent CODING","description":"Use the prebuilt PawSQL repository connector to review SQL on Tencent CODING commits and merge requests.","href":"/en/user-guide/cicd/coding"},{"title":"Integrate GitHub","description":"Use the prebuilt PawSQL repository connector to review SQL on GitHub pushes and pull requests.","href":"/en/user-guide/cicd/github"},{"title":"Integrate GitLab","description":"Use the prebuilt PawSQL repository connector to review SQL on GitLab pushes and merge requests.","href":"/en/user-guide/cicd/gitlab"},{"title":"Integrate a BlueKing Pipeline","description":"Use the prebuilt PawSQL connector to review SQL and enforce a quality gate in a BlueKing pipeline.","href":"/en/user-guide/cicd/blueking"},{"title":"OpenAPI Pipeline Integration","description":"Submit changed SQL from any CI/CD runner, wait for PawSQL analysis, and convert the result into a build decision.","href":"/en/user-guide/cicd/openapi-pipeline"},{"title":"Integrate a Platform Without a Prebuilt Connector","description":"Evaluate CI/CD systems and internal engineering platforms that lack a prebuilt connector, and choose OpenAPI, webhooks, or an enterprise integration service.","href":"/en/user-guide/cicd/unsupported-platforms"},{"title":"Webhook Integration Model","description":"Understand signature validation, filtering, asynchronous processing, retries, and duplicate delivery in event-driven integrations.","href":"/en/user-guide/cicd/webhook"},{"title":"Troubleshoot CI/CD Integrations","description":"Diagnose webhook delivery, SQL collection, authentication, processing, gate, and feedback failures by symptom.","href":"/en/user-guide/cicd/logs-troubleshooting"}]}]}]},{"tab":"Use Cases \u0026 Features","icon":"layers","pages":[{"title":"Use Cases \u0026 Features","href":"/en/use-cases"}]},{"tab":"API","icon":"code","pages":[{"title":"API","href":"/api-reference/sql-audit-tasks/create-audit-task"}]},{"tab":"Changelog","icon":"activity","pages":[{"title":"Changelog","href":"/en/changelog/engine"}]}]}]},"title":"CI/CD and Platform Integrations Overview - PawSQL","buildId":"dpl_2oYXwqkEXirXBPk8wV1FtM5USFWi","deploymentId":"dpl_2oYXwqkEXirXBPk8wV1FtM5USFWi","dynamics":[],"chunks":[]}