【Oracle Database が MCP に対応】 Oracle SQLcl 25.2 に MCP Server 機能を追加。AI アシスタントが安全に DB へ接続し、クエリや SQLcl コマンドを実行可能にした。 ・VS Code 用 Oracle SQL Developer 拡張が SQLcl＋MCP を自動登録 ・list‑connections で保存済み接続を一覧表示 ・run‑sql で SQL／PLSQL、run‑sqlcl で SQLcl コマンドを実行 ・操作はすべて DBTOOLS$MCP_LOG に自動記録して監査可能 本番利用では最小権限ユーザー＋読取専用レプリカ環境の利用を強く推奨。MCP Tools は毎月拡充予定。

Be sure to check out Justin's talk this week on our OCI DBTools service and how #Kscope25

Epic 2 weeks on tap: This week get to hang with @HeliFromFinland in Miami AND introduce a new startup to the world using our dbtools and 23ai platform.

Node/Java/Python examples of using p12 wallet from oci dbtools stored connections. Making all languages, from a single definition of a connection. github.com/krisrice/dbtools-… ( more doc/comment coming soon )

I have just released the Formatter Settings for @oraclesqlcl 23.3.0. The settings also work in @OracleSQLDev 23.1.1. However, you need to use SQLcl's dbtools-common.jar to make it work, because SQLcl is using an updated grammar for #SQL and #PLSQL. github.com/Trivadis/plsql-fo…

go to ~/.dbtools/connections/ mkstore -modifyEntry is your friend ;) berxblog.blogspot.com/2023/0…

We have a "DbTools"-Container which contains the dacpac matching the other containers. When a new version of the solutiin is deployed via CD, the dacpac (DB version for those not using MS SQL Server) is published to the DB. We exactly treat DB updates like code updates.

Customer: show us everything you've done with DBTools since 2017. Me:

DB’s this is what we mean by shooting the wrong hand in press, how it locks your hip and your dead at the release. #YouHaveToLoveWatchingFilm #FilmStudy #DidYouGetBetterToday #DBTools Even the best make mistakes but they learn, apply it and rep it to be right on game day!!!

This was a @CrossFit tweet...22.1 dbtools work is coming along nicely however!

Cheers to early Spring preview and our newest dbtools product manager agreeing to come aboard :)

We have 14 Consoles in @OracleCloud and growing. All UX for creating Database related services such as, all database offerings, GoldenGate, DBTools, Migrations, APEX, .... eeho.fa.us2.oraclecloud.com/…

Same reason I refuse to add a 'Truncate' button in our dbtools.

Oh and those labs? Brought to you by @hiphopengineer1 and her awesome team, plus DBTools labs put together by @btspendo !

My Top 10 Oracle DBTools Tech List: 1. Java SQL/PLSQL Parser & script engine 2. Common lib=1 code base 3. HTTP/JSON->SQL->JSON/HTTP 4. SQLcl w/js 5. SQLDevWeb 6. Auto Liquibase 7. SQLDev Modeler 8. SQL results formatter 9. DB REST API 10. The People Who Make it Happen

Blog post 1,000 is a GIF party! A deep dive on our new DBTools Service's SQL Worksheet - #oracle #100DaysOfCloud #sql #database thatjeffsmith.com/archive/20…

A tech tip for @OracleSQLDev - web, desktop, or CLI...using AutoTrace to see what your query is doing And some blog posts you can read on the subject for our DBTools - thatjeffsmith.com/archive/ta…

Securely, easily connect to and work with your @OracleDatabase in @OracleCloud for free. thatjeffsmith.com/archive/20… Brought to you by our DBTools team :)

I didn't speed anything up in this GIF, that's real-time demo of @oraclesqlcl calling into DBTools service to get connection/wallet info to connect to my Autonomous @OracleDatabase

All that great content, even more to come tomorrow! To toot my own horn, I'll be sharing Tips & Tricks across ALL of our DBTools stack @OracleREST @oraclesqlcl @OracleSQLDev