Having trouble with your AI Agent and running an Oracle Database connection with our SQLcl MCP Server?
It might look like this –
What happened? SQLcl can connect, and so can my SQL Developer VS Code extension???
The problem is that local MCP Servers appear in private environments, they do NOT inherit your system or user defined Environment Variables.
So, if you have a database connection that looks like this…
… You need a way to pass the location of the TNSNames.ora file to your Agent when SQLcl is run.
The solution
In your agent’s MCP configuration JSON file, simply add a line for the TNS_ADMIN environment variable.
Something like, this –
{
"mcpServers": {
"sqlcl": {
"command": "/opt/sqlcl/25.4/sqlcl/bin/sql",
"args": ["-mcp"],
"env" : {"TNS_ADMIN" : "/Users/thatjeffsmith"}
}
}
}
Line 6 is the important one.
Now, your agent MAY need to be restarted. Some of them will detect the change and reload, others will give you the option to force a reload, and some will make you restart the agent application itself.
Once you have ‘done the needful’, you will see something like this –
So now I can go back to my Agent, tell them I’ve fixed our stuff, and pick up where I left off!
I hope this helps! This came up more than a few times, which surprised me because we need to mention this explicitly in our Oracle SQLcl MCP Docs.
The post Handling TNS database connections with Oracle MCP (SQLcl) first appeared on ThatJeffSmith.
PakarPBN
A Private Blog Network (PBN) is a collection of websites that are controlled by a single individual or organization and used primarily to build backlinks to a “money site” in order to influence its ranking in search engines such as Google. The core idea behind a PBN is based on the importance of backlinks in Google’s ranking algorithm. Since Google views backlinks as signals of authority and trust, some website owners attempt to artificially create these signals through a controlled network of sites.
In a typical PBN setup, the owner acquires expired or aged domains that already have existing authority, backlinks, and history. These domains are rebuilt with new content and hosted separately, often using different IP addresses, hosting providers, themes, and ownership details to make them appear unrelated. Within the content published on these sites, links are strategically placed that point to the main website the owner wants to rank higher. By doing this, the owner attempts to pass link equity (also known as “link juice”) from the PBN sites to the target website.
The purpose of a PBN is to give the impression that the target website is naturally earning links from multiple independent sources. If done effectively, this can temporarily improve keyword rankings, increase organic visibility, and drive more traffic from search results.