🌐 网站概览
这个网站是干嘛的?
页面标题: SQL Online IDE - Fast SQL Editor | SQL Compiler
meta描述: SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics
关键词: sql online,sql,online sql compiler,duckdb,pglite,mariadb,mariadb online,mysql,mysql online,posgresql,posgresql online,mssql, mssql online, oracle, oracle online,sqlite,sqlite online,sqlite viewer,sqlite editor,sqlite manager,sqlite browser,select,insert,update,delete,sql test,db online,database online,sql fiddle,sqlite fiddle,sql test,data science,data world,world data,free db,free database,db free,database free
页面内容预览 (前400字):
Wait Import Export Run Syntax Table Syntax History Chart for Data Science – Change first word "SELECT" to "QLINE-SELECT" SELECT QLINE-SELECT – Axis X: – X - column name, axis: x1, x2, ..xn Value: Number – L - column name, axis: l Value: Text – T - column name, axis: t Value: UnixTime Number – Axis Y: – Y - column name, axis: y1, y2, ..yn Value: Number – Y - color line: y_cFF00FF (HEX6) -
页面结构速览
| 指标 | 当前值 | 标准值 | 状态 |
|---|---|---|---|
| H1标签 | 0 个 | 1 个 | ❌ H1数量不对 |
| H2标签 | 1 个 | >=2 个 | ❌ H2太少 |
| meta描述 | 269 字符 | >50 字符 | ✅ |
| 图片alt属性 | 0/0 | 全部 | ❌ 图片缺alt |
| OpenGraph | 无 | 应有 | ❌ 没有OG标签 |
| ### 📋 备案信息 |
❌ 缺少 ICP 备案号和公安备案号
在中国运营的网站,ICP 备案是法律强制要求。没有备案号不仅违法,
搜索引擎和 AI 也会将其视为信任信号缺失,影响权威性。
建议: 在页脚加上:
<a href="https://beian.miit.gov.cn/" target="_blank" rel="noopener">你的ICP备案号</a>
<a href="http://www.beian.gov.cn/" target="_blank" rel="noopener">你的公安备案号</a>
📝 网站真实代码(抓取自 https://sqliteonline.com)
以下是从你网站 HTML 里提取的代码,供参考分析。
<head> 区域原始代码
<head>
<meta charset="utf-8"/>
<style>.hint-br {position: absolute;padding: 10px 20px;color: #fff;background-color: #ed5565;z-index: 9999999;border-radius: 5px;left: 50%;top: 50%;transform: translate(-50%, -50%);width: 400px;box-shadow: 0 3px 6px -1px rgb(0 0 0 / 12%), 0 10px 36px -4px rgb(77 96 232 / 30%);}@media only screen and (max-width: 576px) { .hint-br {width:100%; } }</style>
<script>
window.sqver = 320304;
(async()=>{function e(e){let t=Math.floor(e/2**32);return[t,t<<8,t<<16,t<<24,e,e<<8,e<<16,e<<24].map((e=>e>>>24))}let t=async e=>{const t=(new TextEncoder).encode(e);return await(async e=>{const t=await crypto.subtle.digest("SHA-256",e);return Array.from(new Uint8Array(t)).map((e=>e.toString(16).padStart(2,"0"))).join("")})(t)},n={},r=Date.now(),o=(e,t,n)=>(e.set
meta 标签
<meta charset="utf-8"/>
<meta content="width=device-width, initial-scale=1.0" name="viewport"/>
<meta content="SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics " id="hdescription" name="description"/>
<meta content="sql online,sql,online sql compiler,duckdb,pglite,mariadb,mariadb online,mysql,mysql online,posgresql,posgresql online,mssql, mssql online, oracle, oracle online,sqlite,sqlite online,sqlite viewer,sqlite editor,sqlite manager,sqlite browser,select,insert,update,delete,sql test,db online,database online,sql fiddle,sqlite fiddle,sql test,data science,data world,world data,free db,free database,db free,database free" id="hkeywords" name="keywords"/>
JSON-LD 结构化数据
❌ 缺少 JSON-LD 结构化数据! AI引擎无法理解页面内容结构。
建议至少添加一个 Organization 类型,代码如下:
<script type="application/ld+json">
{
"@context": "https://schema.org",
"@type": "Organization",
"name": "SQL Online IDE - Fast SQL Editor | SQL Compiler",
"url": "https://sqliteonline.com",
"description": "SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics "
}
</script>
H1 主标题
❌ 缺少 H1 标签! 搜索引擎和AI都无法确定页面的核心主题。
加上这个:
<h1>SQL Online IDE - Fast SQL Editor | SQL Compiler</h1>
H2 章节标题
<h2 id="div-html-name">Syntax</h2>
<body> 区域开头
<html><body class="sqlite">
<div class="d-lock bga4" id="lock-wait" style="display: block"><div class="cl-block"><div class="cl-spin"></div></div><div class="cl-block">Wait</div></div>
<main id="sql-online">
<nav id="main-col-left" style="width: 220px">
<header class="main-menu-add">
<div class="main-menu-add-left">
<ul class="menu-top nosel">
<li><button class="btn bn" id="menu-pricing" title="P
导航结构 <nav>
<nav id="main-col-left" style="width: 220px">
<header class="main-menu-add">
<div class="main-menu-add-left">
<ul class="menu-top nosel">
<li><button class="btn bn" id="menu-pricing" title="Pricing">Pricing</button></li>
<li><button class="btn bn" id="menu-help" title="help">Help</button></li>
<li><
📊 综合评分概览
| 评估维度 | 权重 | 得分 | 评级 | 星级 | 锐评 |
|---|---|---|---|---|---|
| AEO (AI引擎优化) | 25% | 44.6 | C | ★★★★☆☆☆☆☆☆ | 存在一些问题,建议针对性优化。… |
| GEO (生成式引擎优化) | 25% | 29.3 | D | ★★☆☆☆☆☆☆☆☆ | 需要重点改进,建议全面优化。… |
| SEO (搜索引擎优化) | 20% | 55.4 | C+ | ★★★★★☆☆☆☆☆ | 存在一些问题,建议针对性优化。… |
| 语义质量 (AI理解度) | 15% | 40.8 | C | ★★★★☆☆☆☆☆☆ | 存在一些问题,建议针对性优化。… |
| 权威度 (E-E-A-T) | 10% | 15.2 | D | ★☆☆☆☆☆☆☆☆☆ | 基础薄弱,需要系统整改。… |
| 语料库 (AI引用价值) | 5% | 28.2 | D | ★★☆☆☆☆☆☆☆☆ | 需要重点改进,建议全面优化。… |
🎯 综合总评
- 总分: 38.6 / 100
- 评级: D+ (较差)
- 星级: ★★★☆☆☆☆☆☆☆
- 评分公式: AEO×25% + GEO×25% + SEO×20% + 语义质量×15% + 权威度×10% + 语料库×5%
需要重点改进,建议全面优化。
⚠️ 严重问题警告
该网站的 GEO/SEO 优化存在严重问题,建议立即整改。
⚠️ GEO (生成式引擎优化): 内容结构存在严重缺陷。缺少 H1、meta、OG 标签等基础配置,AI 爬虫抓取后难以理解页面内容。
📋 结论: 建议立即进行全面的 GEO/SEO 优化整改,以提升搜索可见度。
🔍 AEO评估结果 (AI引擎优化)
AEO (Answer Engine Optimization) 评估你的网站在 ChatGPT、Claude、Perplexity 等 AI 引擎中的可见性和可引用性。
AI爬虫访问 (权重: 20%)
得分: 100.0 / 100
状态: ok
抓取结果:
- robots_url: https://sqliteonline.com/robots.txt
- content: User-agent: *
Allow: /
Sitemap: https://sqliteonline.com/sitemap.xml - results: [{‘crawler’: ‘百度文心一言’, ‘description’: ‘百度搜索 + 文心大模型’, ‘agent’: ‘Baiduspider’, ‘allowed’: True}, {‘crawler’: ‘字节豆包’, ‘description’: ‘字节跳动/抖音/豆包AI’, ‘agent’: ‘Bytespider’, ‘allowed’: True}, {‘crawler’: ‘360AI’, ‘description’: ‘360搜索 + 360智脑’, ‘agent’: ‘360Spider’, ‘allowed’: True}, {‘crawler’: ‘搜狗’, ‘description’: ‘搜狗搜索 + 搜狗AI’, ‘agent’: ‘Sogou web spider’, ‘allowed’: True}, {‘crawler’: ‘神马’, ‘description’: ‘UC/神马搜索’, ‘agent’: ‘YisouSpider’, ‘allowed’: True}, {‘crawler’: ‘Kimi’, ‘description’: ‘月之暗面 Kimi’, ‘agent’: ‘KimiBot’, ‘allowed’: True}, {‘crawler’: ‘DeepSeek’, ‘description’: ‘深度求索 DeepSeek’, ‘agent’: ‘DeepSeekBot’, ‘allowed’: True}, {‘crawler’: ‘阿里通义千问’, ‘description’: ‘阿里巴巴通义千问’, ‘agent’: ‘TongyiBot’, ‘allowed’: True}, {‘crawler’: ‘腾讯混元’, ‘description’: ‘腾讯混元大模型’, ‘agent’: ‘TencentPR’, ‘allowed’: True}, {‘crawler’: ‘智谱ChatGLM’, ‘description’: ‘智谱AI ChatGLM’, ‘agent’: ‘ChatGLMBot’, ‘allowed’: True}, {‘crawler’: ‘讯飞星火’, ‘description’: ‘科大讯飞星火大模型’, ‘agent’: ‘iFlytekBot’, ‘allowed’: True}, {‘crawler’: ‘OpenAI’, ‘description’: ‘OpenAI GPT 系列’, ‘agent’: ‘GPTBot’, ‘allowed’: True}, {‘crawler’: ‘Anthropic’, ‘description’: ‘Anthropic Claude’, ‘agent’: ‘ClaudeBot’, ‘allowed’: True}, {‘crawler’: ‘Perplexity’, ‘description’: ‘Perplexity AI’, ‘agent’: ‘PerplexityBot’, ‘allowed’: True}, {‘crawler’: ‘Google AI’, ‘description’: ‘Google AI 扩展’, ‘agent’: ‘Google-Extended’, ‘allowed’: True}, {‘crawler’: ‘Common Crawl’, ‘description’: ‘Common Crawl 语料库’, ‘agent’: ‘CCBot’, ‘allowed’: True}]
评分原理: 百度文心一言(Baiduspider)、字节豆包(Bytespider)、Kimi(KimiBot)、DeepSeek等AI引擎使用专用爬虫抓取网页内容。通过robots.txt明确允许这些爬虫访问,您的知识才能被国内主流AI引用。
得分公式: 得分 = (允许的AI爬虫数量 / 总AI爬虫数量) × 100
整改方案:
被禁止的AI爬虫,在robots.txt中添加:
User-agent: Baiduspider
Allow: /
User-agent: Bytespider
Allow: /
User-agent: KimiBot
Allow: /
本检测由 GEO评估工具 提供,检测了 16 个国内外主流 AI 爬虫的访问权限。
详细检查结果:
| 爬虫名称 | 代理标识 | 是否允许 |
|---|---|---|
| 百度文心一言 | Baiduspider | ✅ |
| 字节豆包 | Bytespider | ✅ |
| 360AI | 360Spider | ✅ |
| 搜狗 | Sogou web spider | ✅ |
| 神马 | YisouSpider | ✅ |
| Kimi | KimiBot | ✅ |
| DeepSeek | DeepSeekBot | ✅ |
| 阿里通义千问 | TongyiBot | ✅ |
| 腾讯混元 | TencentPR | ✅ |
| 智谱ChatGLM | ChatGLMBot | ✅ |
| 讯飞星火 | iFlytekBot | ✅ |
| OpenAI | GPTBot | ✅ |
| Anthropic | ClaudeBot | ✅ |
| Perplexity | PerplexityBot | ✅ |
| Google AI | Google-Extended | ✅ |
| Common Crawl | CCBot | ✅ |
llms.txt配置 (权重: 15%)
得分: 40.0 / 100
状态: partial
抓取结果:
- llms_url: https://sqliteonline.com/llms.txt
- status_code: 200
- file_size: 138542
- content_preview: <!DOCTYPE html>