AdvisorFinder MCP Server vs StackQL MCP Server
A side-by-side look at the AdvisorFinder MCP Server and StackQL MCP Server MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose AdvisorFinder MCP Server for databases work as a local process; choose StackQL MCP Server for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose AdvisorFinder MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You have the keys it needs:
ADVISORFINDER_MCP_URL. - You want tools like
search_advisors, get_advisor, check_advisor.
Choose StackQL MCP Server when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You want tools like
describe_method, list_methods, list_providers.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 57/100 · Good | 69/100 · Great |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | Not declared | Not declared |
| Pricing | Not declared | Free |
| Required env vars | ADVISORFINDER_MCP_URL | None listed |
| Verified owner | Community listing | Community listing |
| GitHub stars | 1 | 1,068 |
| Directory activity | 1 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 7 | 15 |
| Full listing | View AdvisorFinder MCP Server | View StackQL MCP Server |
Tools & capabilities
AdvisorFinder MCP Server tools 7
search_advisorsSearch SEC-registered investment adviser representatives (IARs) by name, firm, city, and/or state. No CRD number needed. At least one of name/firm/city/state is required — e.g. browse by city+state alone, or search by name. Returns, per match: CRD, name, the firm(s) they're linked to (with branch city/state), a four-state disclosure status (none_reported / disclosed_no_detail / disclosed_with_detail / unknown — never "clean"), and a link to the advisor's full SEC IAPD record. Data is derived from SEC IAPD / FINRA BrokerCheck registration feeds, not real-time.get_advisorGet the full profile for an investment adviser representative (IAR) by CRD number — no need to search first if you already have it. Returns employment history (current firm first, then previous), exams passed, the states where they hold an investment-adviser registration (`advisory_states`; broker-dealer state registrations are reported separately as a labeled count in `also_registered_as_broker`, because selling securities is not the same as giving investment advice), professional designations (always labeled self-reported — none of this data is independently verified), years in the industry, and four-state disclosure status (never phrased as "clean"/"safe": none_reported / disclosed_no_detail / disclosed_with_detail / unknown). Data is derived from SEC IAPD / FINRA BrokerCheck.check_advisorQuick yes/no-style verification of an advisor: is their registration active, which states they hold an investment-adviser registration in (`advisory_states`, with any broker-dealer state registrations reported separately as a labeled count in `also_registered_as_broker`), how long they have been in the industry, and their four-state disclosure status. Accepts EITHER a CRD number (all digits) OR a name — optionally narrowed by firm/state to disambiguate common names. If a name matches more than one advisor, returns candidates instead of guessing; re-run with the CRD from the list. This tool never returns a numeric risk score — only the underlying facts (registration status, disclosure status) so you can judge for yourself.find_bookable_advisorsSearch advisors listed on AdvisorFinder's marketplace — professionals with public profiles you can view and contact directly. This searches only AdvisorFinder members (a few hundred advisors), not the full SEC roster; use search_advisors for the full roster. All filters are optional — browsing with none of them is fine, since this tool's scope is already narrow. `specialty` matches against the advisor's bio, client description, quick facts, and credentials (case-insensitive substring). Returns, per member: their self-provided profile info (bio, credentials, pricing, minimum account size, education, and more), a link to their full AdvisorFinder profile, AND regulatory facts for their CRD. Members whose CRD is in our SEC dataset get the same registration status and four-state disclosure status check_advisor reports — never softened. Members whose CRD is NOT in our SEC dataset (typically state-registered or BD-side advisors) get a labeled note saying so, with FINRA BrokerCheck / SEC IAPD verify links — never presented as if clean. AUM and client-count figures are self-reported by the advisor, not regulatory data, and are always labeled as such. Being listed here is a business relationship with AdvisorFinder, not an endorsement, and never affects how any advisor ranks in search_advisors/check_advisor.search_firmsSearch SEC- and state-registered investment adviser FIRMS by name and/or state. Matches on the firm's primary name, legal name, or any "also known as" prior name on file. Returns, per match: CRD, name, city/ state, AUM band, advisor headcount, and a link to the firm's SEC IAPD record. State-registered-only firms (not SEC-registered) are included but flagged — purely state-registered firms have no advisor rosters at all; state-listed firms showing rosters are dual-registered.get_firmGet the full profile for an investment adviser FIRM by CRD number: identity, address, website, AUM band, headcount, who they serve and how they charge (rendered as lists), any disclosure flag, state registrations, office locations (private-residence addresses are withheld per SEC privacy rules), prior/other names, fee details from their ADV Part 2A brochure (marked as estimated when it is), and how many individual advisor records we have on file for them (an empty roster does not necessarily mean an empty firm — see the caveat when that happens). State-registered-only firms get a reduced profile.get_database_statsOverall stats about our data: how many firms and advisors we cover, when each data source was last refreshed (vintages), and a full four-state disclosure tally — INCLUDING the 'unknown' bucket (advisors where we simply don't have disclosure detail on file; that is not the same as a clean record). Also states coverage scope explicitly: we do not claim to cover the whole US advisor population, only SEC-registered firms and their active reps.
StackQL MCP Server tools 15
describe_methodFull I/O contract for one method: every input with its param_type (input_required params become exact-match WHERE predicates; input_optional ones may be added) and every output field, which are the columns a SELECT or RETURNING can reference. Call it after list_methods and before the first query against a method; there is no resource-level equivalent because each method returns its own shape. Requires provider, service, resource, method.list_methodsAccess methods (HTTP operations) for a resource with their SQL verb and required params. Pick the method whose verb matches the intent and whose required params you can supply, then describe_method it. Call when composing SQL from scratch against an unfamiliar resource; not needed when executing a vetted query library template. Requires provider, service, resource.list_providersAvailable cloud/SaaS providers (top of the hierarchy). No inputs.list_registryProviders (and their versions) available in the configured registry. Distinct from list_providers, which lists only providers already pulled. Optional provider arg lists versions for that provider.list_resourcesResources under a provider.service. Requires provider and service.list_servicesServices under a provider. Requires provider.pull_providerInstall a single provider from the registry into the local approot cache. Requires provider; version is optional (latest published is pulled when empty). Writes only local cache state; no cloud control/data plane effect.query_library_getRetrieve a query library entry by id. Without params: returns the raw template, param declarations and notes (adapt from it when no exact match exists). With params: the server validates values and returns rendered SQL plus which tool to execute it with (run_select_query or run_mutation_query). Read-only, no credentials.query_library_searchSearch the curated StackQL query library by natural-language intent. Returns ranked template ids. Consult before composing SQL from scratch; follow with query_library_get, which validates params and surfaces any the index omits. Read-only, no credentials.reload_credentialsLive-reload provider credentials: re-sources the server's configured env file into the process environment, invalidates cached auth contexts, and reports resolution status for every installed provider (optional provider arg filters the report; changed field flags values that differ from before). Never returns secret values. Credentials resolve automatically at query time - never call this at session start or before queries. Call only after a query fails with a credential resolution error (fix the env file first, then reload, then retry) or when the user says credentials have been rotated or changed. If the report shows changed: false after a failure, the file was not updated - ask the user rather than retrying.run_lifecycle_operationExecute a stackql EXEC lifecycle operation (eg EXEC aws.ec2.instances.start_instances ...). Real cloud side effects. Discover available operations and required params via list_methods and describe_method. Returns {messages, timestamp}. Gated by server mode.run_mutation_queryExecute INSERT/UPDATE/REPLACE/DELETE against the provider. Real side effects. Returns {messages, timestamp}. Gated by server mode. Consult query_library_search for a vetted template before composing SQL from scratch; when the SQL came from a library entry, pass its id as source.- +3 more on the listing page
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
AdvisorFinder MCP Server
{
"mcpServers": {
"mcp-56": {
"command": "uvx",
"args": [
"advisorfinder-mcp"
],
"env": {
"ADVISORFINDER_MCP_URL": "YOUR_ADVISORFINDER_MCP_URL_HERE"
}
}
}
}
StackQL MCP Server
{
"mcpServers": {
"stackql-mcp-server": {
"command": "npx",
"args": [
"-y",
"@stackql/mcp-server"
]
}
}
}
Frequently asked questions
AdvisorFinder MCP Server is categorized under Databases and uses a local stdio subprocess. StackQL MCP Server belongs to Databases and uses a local stdio subprocess. Pick AdvisorFinder MCP Server for databases work and StackQL MCP Server for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
AdvisorFinder MCP Server has no declared pricing — check the project's own site. StackQL MCP Server is listed as free. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add mcp-56 and stackql-mcp-server as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, AdvisorFinder MCP Server has a quality signal of 57/100 (Good) with 1 views, 0 installs and 1 GitHub stars. StackQL MCP Server has 69/100 (Great) with 3 views, 0 installs and 1,068 GitHub stars.