175 lines
8.0 KiB
HTML
175 lines
8.0 KiB
HTML
<!doctype html>
|
|
<html lang="zh-CN">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
<title>快速开始 · OpsxDB 文档</title>
|
|
<meta name="description" content="OpsxDB 桌面数据库工作台用户文档 — 连库、写 SQL、看结果；MySQL / PostgreSQL / SQL Server / Oracle / SQLite / Redis 内置驱动，SSH 隧道与 SSL 加密。">
|
|
<link rel="icon" type="image/svg+xml" href="data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2064%2064%22%3E%3Cdefs%3E%3ClinearGradient%20id%3D%22g%22%20x1%3D%220%22%20y1%3D%220%22%20x2%3D%2264%22%20y2%3D%2264%22%20gradientUnits%3D%22userSpaceOnUse%22%3E%3Cstop%20offset%3D%220%22%20stop-color%3D%22%23059669%22%2F%3E%3Cstop%20offset%3D%221%22%20stop-color%3D%2206B6D4%22%2F%3E%3C%2FlinearGradient%3E%3C%2Fdefs%3E%3Crect%20width%3D%2264%22%20height%3D%2264%22%20rx%3D%2214%22%20fill%3D%22url(%23g)%22%2F%3E%3Cg%20stroke%3D%22%23fff%22%20stroke-width%3D%224.5%22%20fill%3D%22none%22%20stroke-linecap%3D%22round%22%3E%3Cellipse%20cx%3D%2232%22%20cy%3D%2220%22%20rx%3D%2215%22%20ry%3D%226.5%22%2F%3E%3Cpath%20d%3D%22M17%2020v24c0%203.6%206.7%206.5%2015%206.5s15-2.9%2015-6.5V20%22%2F%3E%3Cpath%20d%3D%22M17%2032c0%203.6%206.7%206.5%2015%206.5s15-2.9%2015-6.5%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E">
|
|
<link rel="stylesheet" href="/docs/assets/docs.css">
|
|
</head>
|
|
<body>
|
|
<svg xmlns="http://www.w3.org/2000/svg" style="display:none" aria-hidden="true">
|
|
<symbol id="i-menu" viewBox="0 0 24 24"><path d="M4 5h16"/><path d="M4 12h16"/><path d="M4 19h16"/></symbol>
|
|
</svg>
|
|
<header class="topbar">
|
|
<div class="topbar-inner">
|
|
<button class="menu-btn" id="menu-btn" aria-label="打开导航"><svg class="i"><use href="#i-menu"/></svg></button>
|
|
<a class="brand" href="/docs">
|
|
<span class="brand-logo"><svg width="28" height="28" viewBox="0 0 64 64" aria-label="OpsxDB"><defs><linearGradient id="lg-docs" x1="0" y1="0" x2="64" y2="64" gradientUnits="userSpaceOnUse"><stop offset="0" stop-color="#059669"/><stop offset="1" stop-color="#06B6D4"/></linearGradient></defs><rect width="64" height="64" rx="14" fill="url(#lg-docs)"/><g stroke="#fff" stroke-width="4.5" fill="none" stroke-linecap="round"><ellipse cx="32" cy="20" rx="15" ry="6.5"/><path d="M17 20v24c0 3.6 6.7 6.5 15 6.5s15-2.9 15-6.5V20"/><path d="M17 32c0 3.6 6.7 6.5 15 6.5s15-2.9 15-6.5"/></g></svg></span>
|
|
<span class="brand-name">OpsxDB <em>文档</em></span>
|
|
</a>
|
|
<span class="ver-badge">v0.1</span>
|
|
<div class="search">
|
|
<input id="search-input" type="search" placeholder="搜索文档…" autocomplete="off" spellcheck="false">
|
|
<div class="search-panel" id="search-panel" hidden></div>
|
|
</div>
|
|
<nav class="top-links">
|
|
<a href="/home">官网</a>
|
|
<a href="/docs/quickstart">快速开始</a>
|
|
</nav>
|
|
</div>
|
|
</header>
|
|
|
|
<div class="layout" id="layout">
|
|
<aside class="sidebar" id="sidebar">
|
|
|
|
<div class="nav-group">
|
|
<div class="nav-group-title">开始使用</div>
|
|
|
|
<a class="nav-link" href="/docs/intro">产品介绍</a>
|
|
|
|
<a class="nav-link active" href="/docs/quickstart">快速开始</a>
|
|
|
|
<a class="nav-link" href="/docs/interface">界面导览</a>
|
|
|
|
</div>
|
|
|
|
<div class="nav-group">
|
|
<div class="nav-group-title">连接与驱动</div>
|
|
|
|
<a class="nav-link" href="/docs/connect">新建连接</a>
|
|
|
|
<a class="nav-link" href="/docs/drivers">驱动支持</a>
|
|
|
|
</div>
|
|
|
|
<div class="nav-group">
|
|
<div class="nav-group-title">SQL 工作台</div>
|
|
|
|
<a class="nav-link" href="/docs/workbench">SQL 工作台</a>
|
|
|
|
<a class="nav-link" href="/docs/results">结果与导出</a>
|
|
|
|
<a class="nav-link" href="/docs/redis">Redis 工作台</a>
|
|
|
|
</div>
|
|
|
|
<div class="nav-group">
|
|
<div class="nav-group-title">安全与 AI</div>
|
|
|
|
<a class="nav-link" href="/docs/security">安全设计</a>
|
|
|
|
<a class="nav-link" href="/docs/ai">AI 助手</a>
|
|
|
|
<a class="nav-link" href="/docs/mcp">MCP 接入</a>
|
|
|
|
</div>
|
|
|
|
<div class="nav-group">
|
|
<div class="nav-group-title">参考</div>
|
|
|
|
<a class="nav-link" href="/docs/faq">常见问题</a>
|
|
|
|
<a class="nav-link" href="/docs/shortcuts">快捷键</a>
|
|
|
|
</div>
|
|
|
|
<div class="sidebar-foot">© 2026 OpsxDB · 本地优先的数据库工作台</div>
|
|
</aside>
|
|
|
|
<main class="content">
|
|
<div class="breadcrumb">文档 <span>/</span> 开始使用 <span>/</span> 快速开始</div>
|
|
<h1 class="page-title">快速开始</h1>
|
|
<div class="page-meta">更新于 2026-10-16</div>
|
|
<article class="md">
|
|
<p>本章从零到出结果：获取安装包 → 建连接 → 执行第一条 SQL。</p>
|
|
<h2 id="sec-1">1. 获取安装包</h2>
|
|
<p>OpsxDB 客户端唯一形态是桌面应用：双击启动，本地后端随应用自动拉起，<strong>无需安装任何依赖、无需手动起服务</strong>。</p>
|
|
<ol>
|
|
<li>打开官网 <a href="https://opsxdb.rlwj.cn">opsxdb.rlwj.cn</a> 下载区（会自动识别系统并高亮对应卡片）。公测期点「申请安装包」发邮件领取安装包（macOS Apple Silicon / Intel · .dmg、Windows x64 · .msi、Linux · AppImage）；正式版发布后同一入口提供直链下载；</li>
|
|
<li>双击 DMG，将 OpsxDB 拖入「应用程序」；</li>
|
|
<li>首次启动自动开始 <strong>30 天全功能试用</strong>——无需注册账号、无需信用卡；</li>
|
|
<li>试用期覆盖全部连接与 AI 能力。个人非商业用途永久免费；商用授权与定价见<a href="/pricing">定价页</a>。</li>
|
|
</ol>
|
|
<h2 id="sec-2">2. 新建连接</h2>
|
|
<ol>
|
|
<li>
|
|
<p>打开应用，进入<strong>连接选择器</strong>，选择数据库类型（如 MySQL）；</p>
|
|
</li>
|
|
<li>
|
|
<p>或者直接粘贴连接 URL，点「填入」自动拆解字段：</p>
|
|
<pre><code>mysql://root:pass@127.0.0.1:3306/shop
|
|
</code></pre>
|
|
</li>
|
|
<li>
|
|
<p>点 <strong>测试</strong> 验证连通性，再点 <strong>保存并连接</strong>。</p>
|
|
</li>
|
|
</ol>
|
|
<p>连接配置保存在本机，密码混淆存储；后续查询只携带会话 ID，不再上送账密。数据库在跳板机后面？连接表单开启 SSH 隧道即可安全直达，见《新建连接》。</p>
|
|
<h2 id="sec-3">3. 第一次查询</h2>
|
|
<ol>
|
|
<li>
|
|
<p>左侧对象树展开库，<strong>点表名</strong>直接查看前 100 行（展开表可看列结构）；</p>
|
|
</li>
|
|
<li>
|
|
<p>打开 SQL 编辑器，输入：</p>
|
|
<pre><code class="language-sql">SELECT * FROM orders ORDER BY id DESC LIMIT 100;
|
|
</code></pre>
|
|
</li>
|
|
<li>
|
|
<p>按 <strong>⌘/Ctrl + Enter</strong> 执行当前语句（或选中的片段）；</p>
|
|
</li>
|
|
<li>
|
|
<p>结果面板支持<strong>复制 / 导出 CSV / 生成 INSERT</strong>，双击单元格即复制。</p>
|
|
</li>
|
|
</ol>
|
|
<h2 id="sec-4">4. 手边没有数据库？</h2>
|
|
<p>本地还没有可连的库？用 Docker 一分钟起一个练手：</p>
|
|
<pre><code class="language-bash">docker run -d --name demo-mysql \
|
|
-e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=shop \
|
|
-p 3306:3306 mysql:8
|
|
</code></pre>
|
|
<p>然后把 <code>mysql://root:pass@127.0.0.1:3306/shop</code> 粘贴进连接表单，点「填入」即可。</p>
|
|
<p>各数据库的接入方式与验收状态见《<a href="/docs/drivers">驱动支持</a>》。</p>
|
|
|
|
</article>
|
|
|
|
<div class="pn-nav">
|
|
|
|
<a class="pn prev" href="/docs/intro"><span class="pn-label">← 上一页</span><span class="pn-title">产品介绍</span></a>
|
|
|
|
|
|
<a class="pn next" href="/docs/interface"><span class="pn-label">下一页 →</span><span class="pn-title">界面导览</span></a>
|
|
|
|
</div>
|
|
|
|
|
|
</main>
|
|
|
|
<aside class="toc">
|
|
<div class="toc-title">本页目录</div>
|
|
<nav class="toc-nav">
|
|
<a class="toc-l2" href="#sec-1">1. 获取安装包</a>
|
|
<a class="toc-l2" href="#sec-2">2. 新建连接</a>
|
|
<a class="toc-l2" href="#sec-3">3. 第一次查询</a>
|
|
<a class="toc-l2" href="#sec-4">4. 手边没有数据库？</a>
|
|
|
|
</nav>
|
|
</aside>
|
|
</div>
|
|
|
|
<script src="/docs/assets/docs.js" defer></script>
|
|
</body>
|
|
</html>
|