236 Star 2.6K Fork 662

dotNET China / SmartSQL

Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
Clone or Download
contribute
Sync branch
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README
Apache-2.0
SmartSQL

SmartSQL

⚡一款方便、快捷的数据库文档查询、生成工具

致力于成为帮助企业快速实现数字化转型的元数据管理工具

visual studio 2019 csharp license release

框架 .Net 支持系统

首页

🚩 项目介绍

SmartSQL 是一款方便、快捷的数据库文档查询、导出工具!从最初仅支持SqlServer数据库、CHM文档格式开始,通过不断地探索开发、集思广益和不断改进,又陆续支持WordExcelPDFHtmlXmlJsonMarkDown等文档格式的导出。同时又扩展支持包括SqlServerMySqlPostgreSQLSQLite等多种数据库的文档查询和导出功能。

🏅开源地址

Gitee
GitHub

🎯下载地址

码云: https://gitee.com/izhaofu/SmartSQL/releases

蓝奏云下载:https://wwoc.lanzoum.com/b04dpvcxe

蓝奏云密码:123

文件下载解压后,双击运行 SmartSQL.exe即可

🚀 本项目力求做最方便、快捷的数据库文档查询生成工具!

💎 数据库支持

  • ✅ SqlServer
  • ✅ MySQL
  • ✅ Oracle
  • ✅ PostgreSQL
  • ✅ SQLite
  • ✅ 达梦
    • DB2
    • TIDB
    • 瀚高
    • kingbase

📖 主要功能

文档的内容都包含什么?

  • 序号 | 列名 | 主键 | 自增 | 数据类型 | 长度 | 允许NULL值 | 默认值 | 备注说明
  • 视图 视图内容SQL脚本
  • 存储过程 存储过程内容SQL脚本

支持导出哪些文档格式?

CHM文档 Excel文档 Word文档 PDF文档
Html文档 Xml文档 Json MarkDown

更新表列的注释,有哪些方式?

  • 通过 文件导入备注,选择文件导入进行更新批注(注释):
    • pdm 由PowerDesigner设计数据库时产生。
    • xml 由Visual Studio设置 实体类库的项目属性,勾选XML文档文件后生成项目时产生。
    • xml 由SmartSQL的 XML导出而产生。

什么是分组管理

  • 可以对数据库中的表、视图、存储过程进行自定义分组
  • 可以对分组对象进行文档批量导出

功能架构

🎉 功能介绍

Dashbord

数据库连接

工具箱

数据库连接

网站导航

数据库连接

数据库连接

数据库连接 数据库连接

连接管理中可以对当前添加的连接进行添加修改删除等操作。

目前支持对SQLServerMySQLOraclePostgreSQL达梦...等6种数据库的支持。

DB2TIDB瀚高等其他关系型数据库的支持正在进行中。

分组管理

分组管理 分组管理

在此可以对数据库中的视图存储过程实现自定义分组,方便管理

同时支持对分组进行排序,将鼠标放在需排序的分组上,当箭头变成➕就可以拖动排序了

常用的分组可置为默认展开不常用的分组置为默认不展开

快捷查询

快捷查询 快捷查询
快捷查询 快捷查询

支持左侧菜单快速检索对象

同时支持右侧主界面快速检索视图等信息

最大亮点是支持双击备注说明列对应单元格快速设置对象注释信息

视图存储过程支持一键查看内容结构、一键复制

导入导出

导入备注 导出文档

支持对视图存储过程进行导出成多种格式的离线文档

支持对XML格式的文档进行导入视图存储过程注释

设置/关于

设置 关于

支持搜索时设置根据前缀模糊搜索和全量模糊搜索

支持对右侧主界面设置多选项卡和单选项卡设置

📰 文档截图

CHM文档

CHM文档 CHM文档

Html文档

Html文档 html文档

Word文档

Word文档 Word文档

Excel文档

Word文档 Word文档

PDF文档

PDF文档 PDF文档

⚡ 近期计划

✅ 收集问题,修复完善基础功能
✅ C#实体代码生成
⏳ 进行中:优化现有Issues中反馈的bug
⏳ 计划中:DB2、TIDB、达梦等数据库支持
⏳ 计划中:对象结构对比功能
⏳ 计划中:表、视图、存储过程同步功能
⏳ ...

🔥 沟通交流

QQ交流群:666483672 作者微信号

由于微信群限制100人后需群主邀请,如需加群请扫码上面二维码加好友本人拉你入群

公众号也将每日定期分享有趣有料有用的开源项目,助力共同

🧧 赞赏作者

你的赞赏就是我前进的动力🏃,
如果SmartSQL给你带来了不少便利,
那就请作者喝杯咖啡☕吧。

❓ 常见问题

PS:如果你有更好方法,欢迎提供改善建议,助力✊该工具越来越好使!

Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document. "Licensor" shall mean the copyright owner or entity authorized by the copyright owner that is granting the License. "Legal Entity" shall mean the union of the acting entity and all other entities that control, are controlled by, or are under common control with that entity. For the purposes of this definition, "control" means (i) the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity. "You" (or "Your") shall mean an individual or Legal Entity exercising permissions granted by this License. "Source" form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files. "Object" form shall mean any form resulting from mechanical transformation or translation of a Source form, including but not limited to compiled object code, generated documentation, and conversions to other media types. "Work" shall mean the work of authorship, whether in Source or Object form, made available under the License, as indicated by a copyright notice that is included in or attached to the work (an example is provided in the Appendix below). "Derivative Works" shall mean any work, whether in Source or Object form, that is based on (or derived from) the Work and for which the editorial revisions, annotations, elaborations, or other modifications represent, as a whole, an original work of authorship. For the purposes of this License, Derivative Works shall not include works that remain separable from, or merely link (or bind by name) to the interfaces of, the Work and Derivative Works thereof. "Contribution" shall mean any work of authorship, including the original version of the Work and any modifications or additions to that Work or Derivative Works thereof, that is intentionally submitted to Licensor for inclusion in the Work by the copyright owner or by an individual or Legal Entity authorized to submit on behalf of the copyright owner. For the purposes of this definition, "submitted" means any form of electronic, verbal, or written communication sent to the Licensor or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, the Licensor for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by the copyright owner as "Not a Contribution." "Contributor" shall mean Licensor and any individual or Legal Entity on behalf of whom a Contribution has been received by Licensor and subsequently incorporated within the Work. 2. Grant of Copyright License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare Derivative Works of, publicly display, publicly perform, sublicense, and distribute the Work and such Derivative Works in Source or Object form. 3. Grant of Patent License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by such Contributor that are necessarily infringed by their Contribution(s) alone or by combination of their Contribution(s) with the Work to which such Contribution(s) was submitted. If You institute patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Work or a Contribution incorporated within the Work constitutes direct or contributory patent infringement, then any patent licenses granted to You under this License for that Work shall terminate as of the date such litigation is filed. 4. Redistribution. You may reproduce and distribute copies of the Work or Derivative Works thereof in any medium, with or without modifications, and in Source or Object form, provided that You meet the following conditions: (a) You must give any other recipients of the Work or Derivative Works a copy of this License; and (b) You must cause any modified files to carry prominent notices stating that You changed the files; and (c) You must retain, in the Source form of any Derivative Works that You distribute, all copyright, patent, trademark, and attribution notices from the Source form of the Work, excluding those notices that do not pertain to any part of the Derivative Works; and (d) If the Work includes a "NOTICE" text file as part of its distribution, then any Derivative Works that You distribute must include a readable copy of the attribution notices contained within such NOTICE file, excluding those notices that do not pertain to any part of the Derivative Works, in at least one of the following places: within a NOTICE text file distributed as part of the Derivative Works; within the Source form or documentation, if provided along with the Derivative Works; or, within a display generated by the Derivative Works, if and wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do not modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendum to the NOTICE text from the Work, provided that such additional attribution notices cannot be construed as modifying the License. You may add Your own copyright statement to Your modifications and may provide additional or different license terms and conditions for use, reproduction, or distribution of Your modifications, or for any such Derivative Works as a whole, provided Your use, reproduction, and distribution of the Work otherwise complies with the conditions stated in this License. 5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work by You to the Licensor shall be under the terms and conditions of this License, without any additional terms or conditions. Notwithstanding the above, nothing herein shall supersede or modify the terms of any separate license agreement you may have executed with Licensor regarding such Contributions. 6. Trademarks. This License does not grant permission to use the trade names, trademarks, service marks, or product names of the Licensor, except as required for reasonable and customary use in describing the origin of the Work and reproducing the content of the NOTICE file. 7. Disclaimer of Warranty. Unless required by applicable law or agreed to in writing, Licensor provides the Work (and each Contributor provides its Contributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for determining the appropriateness of using or redistributing the Work and assume any risks associated with Your exercise of permissions under this License. 8. Limitation of Liability. In no event and under no legal theory, whether in tort (including negligence), contract, or otherwise, unless required by applicable law (such as deliberate and grossly negligent acts) or agreed to in writing, shall any Contributor be liable to You for damages, including any direct, indirect, special, incidental, or consequential damages of any character arising as a result of this License or out of the use or inability to use the Work (including but not limited to damages for loss of goodwill, work stoppage, computer failure or malfunction, or any and all other commercial damages or losses), even if such Contributor has been advised of the possibility of such damages. 9. Accepting Warranty or Additional Liability. While redistributing the Work or Derivative Works thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty, indemnity, or other liability obligations and/or rights consistent with this License. However, in accepting such obligations, You may act only on Your own behalf and on Your sole responsibility, not on behalf of any other Contributor, and only if You agree to indemnify, defend, and hold each Contributor harmless for any liability incurred by, or claims asserted against, such Contributor by reason of your accepting any such warranty or additional liability. END OF TERMS AND CONDITIONS APPENDIX: How to apply the Apache License to your work. To apply the Apache License to your work, attach the following boilerplate notice, with the fields enclosed by brackets "[]" replaced with your own identifying information. (Don't include the brackets!) The text should be enclosed in the appropriate comment syntax for the file format. We also recommend that a file or class name and description of purpose be included on the same "printed page" as the copyright notice for easier identification within third-party archives. Copyright [yyyy] [name of copyright owner] Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

About

🔥🔥🔥 一款方便、快捷的数据库文档查询、生成工具,支持SqlServer/Oracle/MySql/PostgreSQL/SQLite数据库表结构文档查询、生成;导出文档支持CHM、Word、Excel、PDF、Html、Xml、Json、MarkDown等多种格式。 expand collapse
Cancel

Contributors

All

Activities

Load More
can not load any more
C#
1
https://gitee.com/dotnetchina/SmartSQL.git
git@gitee.com:dotnetchina/SmartSQL.git
dotnetchina
SmartSQL
SmartSQL
master

Search

53164aa7 5694891 3bd8fe86 5694891